P2K_SMGCD#
Functionality:#
This database function will return the actual code value for a specific ID, upon identifying the source table.Parameters:#
CODE_ID | The actual ID field within the database |
TABLE_ALIAS | This is the abbreviation for the table (you can see this in IMTD) for the corresponding code |
Returns: #
Varchar2(30)Errors: #
If an invalid parameter is passed, then NULL is returnedIf there is no value or record for that ID and alias pair, then NULL is returned
Example: #
P2K_SMGCD(DPS_ID,'DPS')
Table Aliases Supported #
(as at Feb 28, 2009 – more may be added with each release)