DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_CO_S_LTR_PR_ARG

Object Details
Object Name: IGS_CO_S_LTR_PR_ARG
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_CO_S_LTR_PR_ARG
Subobject Name:
Status: VALID


IGS_CO_S_LTR_PR_ARG holds relationship between bind variables used in the code_block field of the system letter parameter type table and the variables that are available in the function calling the dynamic SQL created from the code_block.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_CO_S_LTR_PR_ARG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnS_LETTER_PARAMETER_TYPE
ColumnBIND_VARIABLE
Columns
Name Datatype Length Mandatory Comments
S_LETTER_PARAMETER_TYPE VARCHAR2 (10) Yes Contains the system recognized parameters that can be merged with letter templates. For example SURNAME, LOCATION, ATT_MODE etc.
BIND_VARIABLE VARCHAR2 (50) Yes Contains the name of the bind variables used in the code_block field of the parent s_letter_parameter_type record
DIRECTION VARCHAR2 (3) Yes Indicates if the bind variable is being passed into or out of the dynamic SQL code block
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT S_LETTER_PARAMETER_TYPE
,      BIND_VARIABLE
,      DIRECTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CO_S_LTR_PR_ARG;

Dependencies

[top of page]

IGS.IGS_CO_S_LTR_PR_ARG does not reference any database object

IGS.IGS_CO_S_LTR_PR_ARG is referenced by following:

SchemaAPPS
SynonymIGS_CO_S_LTR_PR_ARG