[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GASNO_DETAIL_ALLOCATIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GASNO_DETAIL_ALLOCATIONS
|
| Subobject Name: | |
| Status: | VALID |
GML_GASNO_DETAIL_ALLOCATIONS contains information about lot, location and pending transaction for an order line of an order that the shipment generated from to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)). The information in this table is based primarily on data stored in related inventory tables such as ic_lots_mst, ic_loct_mst and ic_tran_pnd.
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_ALLOCATIONS 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 for the order line. | ||
| TRANS_ID | NUMBER | Unique key for inventory transaction | ||
| LOT_NO | VARCHAR2 | (32) | Code for lot | |
| VENDOR_LOT_NO | VARCHAR2 | (32) | Vendor lot number | |
| SUBLOT_NO | VARCHAR2 | (32) | Code for sublot | |
| LOT_DESCRIPTION | VARCHAR2 | (40) | Description of the lot | |
| LOT_STATUS | VARCHAR2 | (4) | Code for lot status | |
| STATUS_DESC | VARCHAR2 | (40) | Description of lot status | |
| LOCATION | VARCHAR2 | (16) | Code for location | |
| LOCT_DESC | VARCHAR2 | (40) | Description for the location | |
| QC_GRADE | VARCHAR2 | (4) | Code for QC grade | |
| QC_GRADE_DESC | VARCHAR2 | (40) | Description for QC grade | |
| REASON_CODE | VARCHAR2 | (4) | Reason code associated with the transaction | |
| LOT_CREATED | DATE | Lot creation date. | ||
| EXPIRE_DATE | DATE | Date the lot should be retested. | ||
| QUANTITY1 | NUMBER | Quantity of the transaction in the primary UOM of an item. | ||
| UOM1_INT | VARCHAR2 | (4) | Internal primary unit of measure. | |
| UOM1_EXT1 | VARCHAR2 | (20) | External primary unit of measure 1. | |
| UOM1_EXT2 | VARCHAR2 | (20) | External primary unit of measure 2. | |
| UOM1_EXT3 | VARCHAR2 | (20) | External primary unit of measure 3. | |
| UOM1_EXT4 | VARCHAR2 | (20) | External primary unit of measure 4. | |
| UOM1_EXT5 | VARCHAR2 | (20) | External primary unit of measure 5. | |
| QUANTITY2 | NUMBER | Quantity of the transaction in the secondary UOM of an item, if it is dual UOM controlled. | ||
| UOM2_INT | VARCHAR2 | (4) | Internal secondary unit of measure. | |
| UOM2_EXT1 | VARCHAR2 | (20) | External secondary unit of measure 1. | |
| UOM2_EXT2 | VARCHAR2 | (20) | External secondary unit of measure 2. | |
| UOM2_EXT3 | VARCHAR2 | (20) | External secondary unit of measure 3. | |
| UOM2_EXT4 | VARCHAR2 | (20) | External secondary unit of measure 4. | |
| UOM2_EXT5 | VARCHAR2 | (20) | External secondary unit of measure 5. | |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links this table to its associated extension table GML_GASNO_DETAIL_ALLOCATIONS_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
, TRANS_ID
, LOT_NO
, VENDOR_LOT_NO
, SUBLOT_NO
, LOT_DESCRIPTION
, LOT_STATUS
, STATUS_DESC
, LOCATION
, LOCT_DESC
, QC_GRADE
, QC_GRADE_DESC
, REASON_CODE
, LOT_CREATED
, EXPIRE_DATE
, QUANTITY1
, UOM1_INT
, UOM1_EXT1
, UOM1_EXT2
, UOM1_EXT3
, UOM1_EXT4
, UOM1_EXT5
, QUANTITY2
, UOM2_INT
, UOM2_EXT1
, UOM2_EXT2
, UOM2_EXT3
, UOM2_EXT4
, UOM2_EXT5
, 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_ALLOCATIONS;
GML.GML_GASNO_DETAIL_ALLOCATIONS does not reference any database object
GML.GML_GASNO_DETAIL_ALLOCATIONS is referenced by following:
GML
GML_GASNO_DETAIL_ALLOCATIONS#
|
|
|
|