[Home] [Help] [Dependency Information]
Object Name: | IGS_CO_S_PERLT_RPTGP_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_CO_S_PERLT_RPTGP_ALL |
Subobject Name: | |
Status: | VALID |
IGS_CO_S_PERLT_RPTGP describes repeating groups in relation to system letter to be produced for person.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_CO_S_PERLT_RPTGP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
CORRESPONDENCE_TYPE LETTER_REFERENCE_NUMBER SPL_SEQUENCE_NUMBER LETTER_REPEATING_GROUP_CD SEQUENCE_NUMBER |
IGS_CO_S_PERLT_RPTGP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
CORRESPONDENCE_TYPE LETTER_REFERENCE_NUMBER SPL_SEQUENCE_NUMBER SUP_REPEATING_GROUP_CD SUP_SPLRG_SEQUENCE_NUMBER |
IGS_CO_S_PERLT_RPTGP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CORRESPONDENCE_TYPE
LETTER_REFERENCE_NUMBER LETTER_REPEATING_GROUP_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
CORRESPONDENCE_TYPE | VARCHAR2 | (10) | Yes | This is a code for the type of correspondence. |
LETTER_REFERENCE_NUMBER | NUMBER | (10) | Yes | The unique identifier for a system letter. |
SPL_SEQUENCE_NUMBER | NUMBER | (10) | Yes | Sequence number to uniquely identify a letter that has been sent to a person. |
LETTER_REPEATING_GROUP_CD | VARCHAR2 | (10) | Yes | Contains the group code that will be used to link repeating parameters within the letter |
SEQUENCE_NUMBER | NUMBER | (10) | Yes | Sequence number to uniquely identify an instance of the group code that will be used to link repeating parameters within the letter. |
SUP_REPEATING_GROUP_CD | VARCHAR2 | (10) | Contains the superior group code that will be used to link repeating parameters within the letter | |
SUP_SPLRG_SEQUENCE_NUMBER | NUMBER | (10) | Sequence number to uniquely identify the superior instance of the group code that will be used to link repeating parameters within the letter. | |
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 | |
REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program | ||
ORG_ID | NUMBER | (15) | Operating Unit Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, CORRESPONDENCE_TYPE
, LETTER_REFERENCE_NUMBER
, SPL_SEQUENCE_NUMBER
, LETTER_REPEATING_GROUP_CD
, SEQUENCE_NUMBER
, SUP_REPEATING_GROUP_CD
, SUP_SPLRG_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
FROM IGS.IGS_CO_S_PERLT_RPTGP_ALL;
IGS.IGS_CO_S_PERLT_RPTGP_ALL does not reference any database object
IGS.IGS_CO_S_PERLT_RPTGP_ALL is referenced by following:
|
|
|