[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_DETAIL_ALLOCATIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GPOAO_DETAIL_ALLOCATIONS
|
| Subobject Name: | |
| Status: | VALID |
GML_GPOAO_DETAIL_ALLOCATIONS contains order line detail allocation data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP)).
This table is based primarily on data stored in the IC_TRAN_PEND table of OPM Inventory..
All columns denoted with an "INT" or "INTERNAL" represent Applications internal values. All columns with "EXT" or "External" represent the equivalent external values sourced from the ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in the GML_GPOA_DETAIL_ALLOCATIONS is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_DETAIL_ALLOCATIONS table to its corresponding extension table GML_GPOAO_DETAIL_ALLOCATIONS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RUN_ID | NUMBER | Transaction Run ID | ||
| LINE_ID | NUMBER | Detail Line ID | ||
| TRANS_ID | NUMBER | Transaction ID | ||
| LOT_NO | VARCHAR2 | (32) | Lot Number | |
| VENDOR_LOT_NO | VARCHAR2 | (32) | Vendor Lot Number | |
| SUBLOT_NO | VARCHAR2 | (32) | Sub Lot Number | |
| LOT_DESCRIPTION | VARCHAR2 | (40) | Lot Description | |
| LOT_STATUS | VARCHAR2 | (4) | Lot Status | |
| STATUS_DESC | VARCHAR2 | (40) | Status Description | |
| LOCATION | VARCHAR2 | (16) | Location | |
| LOCT_DESC | VARCHAR2 | (40) | Location Description | |
| QC_GRADE | VARCHAR2 | (4) | QC Grade | |
| QC_GRADE_DESC | VARCHAR2 | (40) | QC Grade Description | |
| REASON_CODE | VARCHAR2 | (4) | Reason Code | |
| LOT_CREATED | DATE | Lot Creation Date | ||
| EXPIRE_DATE | DATE | Lot Expiration Date | ||
| QUANTITY1 | NUMBER | Transaction Quantity | ||
| UOM1_INT | VARCHAR2 | (4) | UOM (Int) | |
| UOM1_EXT1 | VARCHAR2 | (20) | UOM (Ext1) | |
| UOM1_EXT2 | VARCHAR2 | (20) | UOM (Ext2) | |
| UOM1_EXT3 | VARCHAR2 | (20) | UOM (Ext3) | |
| UOM1_EXT4 | VARCHAR2 | (20) | UOM (Ext4) | |
| UOM1_EXT5 | VARCHAR2 | (20) | UOM (Ext5) | |
| QUANTITY2 | NUMBER | Transaction Quantity 2 | ||
| UOM2_INT | VARCHAR2 | (4) | UOM 2 (Int) | |
| UOM2_EXT1 | VARCHAR2 | (20) | UOM 2 (Ext1) | |
| UOM2_EXT2 | VARCHAR2 | (20) | UOM 2 (Ext2) | |
| UOM2_EXT3 | VARCHAR2 | (20) | UOM 2 (Ext3) | |
| UOM2_EXT4 | VARCHAR2 | (20) | UOM 2 (Ext4) | |
| UOM2_EXT5 | VARCHAR2 | (20) | UOM 2 (Ext5) | |
| TRANSACTION_RECORD_ID | NUMBER | Transaction Record ID | ||
| 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_GPOAO_DETAIL_ALLOCATIONS;
GML.GML_GPOAO_DETAIL_ALLOCATIONS does not reference any database object
GML.GML_GPOAO_DETAIL_ALLOCATIONS is referenced by following:
GML
GML_GPOAO_DETAIL_ALLOCATIONS#
|
|
|
|