[Home] [Help] [Dependency Information]
Object Name: | IGI_EXP_DIAL_DOC_TEMP |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_EXP_DIAL_DOC_TEMP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_EXP_DIAL_DOC_TEMP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DOCUMENT_NUM
DOCUMENT_ID AMOUNT ENGAGEMENT_NUMBER SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_ID | NUMBER | (15) | Yes | Document identifier. For example, invoice identifier. |
DOCUMENT_NUM | VARCHAR2 | (50) | Yes | Associated document number |
ACCOUNT | VARCHAR2 | (25) | Yes | Natural account number on associated document |
DIAL_UNIT_LINK | VARCHAR2 | (1) | Yes | Dialog unit link flag |
SESSION_ID | NUMBER | (15) | Yes | Session identifier |
DIALOGUE_UNIT_ID | NUMBER | (15) | Unique identifer of dialog unit. | |
DOCUMENT_DATE | DATE | Creation date of associated document | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
AMOUNT | NUMBER | Amount | ||
ENGAGEMENT_NUMBER | VARCHAR2 | (25) | Engagement number |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_ID
, DOCUMENT_NUM
, ACCOUNT
, DIAL_UNIT_LINK
, SESSION_ID
, DIALOGUE_UNIT_ID
, DOCUMENT_DATE
, DESCRIPTION
, AMOUNT
, ENGAGEMENT_NUMBER
FROM IGI.IGI_EXP_DIAL_DOC_TEMP;
IGI.IGI_EXP_DIAL_DOC_TEMP does not reference any database object
IGI.IGI_EXP_DIAL_DOC_TEMP is referenced by following:
|
|
|