[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GASNO_DETAIL_TEXT |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GASNO_DETAIL_TEXT
|
| Subobject Name: | |
| Status: | VALID |
GML_GASNO_DETAIL_TEXT contains text data for a line that the shipment generated from to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)).
All columns denoted with an "INT" represent Applications internal values. All columns with "EXT" represent the equivalent external values.
Each row in the GML_GASNO_DETAIL_TEXT is purged after the data is written to the data file.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RUN_ID | NUMBER | Run Id | ||
| LINE_ID | NUMBER | Surrogate key to uniquely identify the line. | ||
| TEXT_ID | NUMBER | A key uniquely identifies text for the line. | ||
| LANG_CODE_INT | VARCHAR2 | (4) | Internal language code indicates the language in which the text is written. | |
| LANG_CODE_EXT1 | VARCHAR2 | (10) | External language code 1. | |
| LANG_CODE_EXT2 | VARCHAR2 | (10) | External language code 2. | |
| LANG_CODE_EXT3 | VARCHAR2 | (10) | External language code 3. | |
| LANG_CODE_EXT4 | VARCHAR2 | (10) | External language code 4. | |
| LANG_CODE_EXT5 | VARCHAR2 | (10) | External language code 5. | |
| PARA_CODE_INT | VARCHAR2 | (4) | Internal paragraph code distinguishes defferent text for one record. A user may enter several different types of text for a record to store different information. | |
| PARA_CODE_EXT1 | VARCHAR2 | (10) | External paragraph code 1. | |
| PARA_CODE_EXT2 | VARCHAR2 | (10) | External paragraph code 2. | |
| PARA_CODE_EXT3 | VARCHAR2 | (10) | External paragraph code 3. | |
| PARA_CODE_EXT4 | VARCHAR2 | (10) | External paragraph code 4. | |
| PARA_CODE_EXT5 | VARCHAR2 | (10) | External paragraph code 5. | |
| SUB_PARACODE | NUMBER | Allows subgrouping information within para_code_int. | ||
| LINE_NO | NUMBER | Line number which allows multiple lines of descriptive text for underlying record. Value -1 is used to recreate key of the underlying record. Value >= 1 for descriptive text. | ||
| TEXT | VARCHAR2 | (80) | Descriptive text. | |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links this table to its associated extension table GML_GASNO_DETAIL_TEST_X. | ||
| CREATION_DATE | DATE | Standard who column | ||
| CREATED_BY | NUMBER | (15) | Standard who column | |
| LAST_UPDATE_DATE | DATE | Standard who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| REQUEST_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_UPDATE_DATE | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT RUN_ID
, LINE_ID
, TEXT_ID
, LANG_CODE_INT
, LANG_CODE_EXT1
, LANG_CODE_EXT2
, LANG_CODE_EXT3
, LANG_CODE_EXT4
, LANG_CODE_EXT5
, PARA_CODE_INT
, PARA_CODE_EXT1
, PARA_CODE_EXT2
, PARA_CODE_EXT3
, PARA_CODE_EXT4
, PARA_CODE_EXT5
, SUB_PARACODE
, LINE_NO
, TEXT
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM GML.GML_GASNO_DETAIL_TEXT;
GML.GML_GASNO_DETAIL_TEXT does not reference any database object
GML.GML_GASNO_DETAIL_TEXT is referenced by following:
GML
GML_GASNO_DETAIL_TEXT#
|
|
|
|