[Home] [Help] [Dependency Information]
Object Name: | IC_TRAN_PND |
---|---|
Object Type: | TABLE |
Owner: | GMI |
FND Design Data: | GMI.IC_TRAN_PND |
Subobject Name: | |
Status: | VALID |
Pending inventory transaction table. Note that this table stores all
pending transactions as well as many completed transactions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IC_TRAN_PND_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANS_ID |
IC_TRAN_PNDI1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_ID
LOT_ID WHSE_CODE LOCATION |
IC_TRAN_PNDI2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DOC_TYPE
DOC_ID LINE_ID |
IC_TRAN_PNDI3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
IC_TRAN_PNDI4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_ID
COMPLETED_IND DOC_TYPE WHSE_CODE |
IC_TRAN_PNDI5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANS_DATE |
IC_TRAN_PNDI6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_ID
COMPLETED_IND DELETE_MARK DOC_TYPE WHSE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANS_ID | NUMBER | (10) | Yes | Unique key for the transaction. |
ITEM_ID | NUMBER | (10) | Yes | Surrogate key for the item. |
LINE_ID | NUMBER | (10) | Yes | Surrogate key for the document line that produced the transaction. |
CO_CODE | VARCHAR2 | (4) | Yes | Company affected by the transaction (company which owns the organization which created the transaction). |
ORGN_CODE | VARCHAR2 | (4) | Yes | Organization which created the transaction. |
WHSE_CODE | VARCHAR2 | (4) | Yes | Warehouse affected by the transaction. |
LOT_ID | NUMBER | (10) | Yes | Surrogate key of the lot. |
LOCATION | VARCHAR2 | (16) | Yes | Location affected by the transaction. |
DOC_ID | NUMBER | (10) | Yes | Surrogate key of the document that created the transaction. |
DOC_TYPE | VARCHAR2 | (4) | Yes | Type of document which created the transaction. |
DOC_LINE | NUMBER | (10) | Yes | Not currently used. |
LINE_TYPE | NUMBER | (5) | Yes | Line type. |
REASON_CODE | VARCHAR2 | (4) | Reason code associated with the transaction. | |
CREATION_DATE | DATE | Yes | Standard who column | |
TRANS_DATE | DATE | Yes | Transaction date. | |
TRANS_QTY | NUMBER | Yes | Quantity of the transaction in the primary UOM of an item. | |
TRANS_QTY2 | NUMBER | Quantity of the transaction in the secodary UOM of an item, if dual UOM controlled. | ||
QC_GRADE | VARCHAR2 | (4) | Grade associated with the transaction. | |
LOT_STATUS | VARCHAR2 | (4) | Lot status associated with the transaction. | |
TRANS_STAT | VARCHAR2 | (4) | Not currently used. | |
TRANS_UM | VARCHAR2 | (4) | Yes | UOM in which trans_qty is expressed. |
TRANS_UM2 | VARCHAR2 | (4) | UOM in which trans_qty2 is expressed. | |
OP_CODE | NUMBER | (15) | Yes | Operator who created the transaction. |
COMPLETED_IND | NUMBER | (5) | Yes | Completed indicator. 0=Pending transaction, 1=Completed transaction. |
STAGED_IND | NUMBER | (5) | Yes | Not currently used. |
GL_POSTED_IND | NUMBER | (10) | Yes | GL posted indicator. 0=Not posted to GL, 1=Posted to GL. |
EVENT_ID | NUMBER | (10) | Yes | Event ID. This column should an optional column; NULL. |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
REQUEST_ID | NUMBER | (15) | Concurrent who column | |
REVERSE_ID | NUMBER | (10) | Indicator of whether this is a reversing transaction. | |
PICK_SLIP_NUMBER | NUMBER | Pick slip number | ||
MVT_STAT_STATUS | VARCHAR2 | (30) | Movement statistics status | |
MOVEMENT_ID | NUMBER | Movement identifier | ||
LINE_DETAIL_ID | NUMBER | Reference to wsh_delivery_details for OMSO doc type | ||
INVOICED_FLAG | VARCHAR2 | (1) | Intercompany Invoice Indicator.This column will be marked as Y once inventory transaction is processed to create inter company AR invoice. | |
INTORDER_POSTED_IND | NUMBER | (5) | Internal Order Intransit GL Posted Indicator. 0 = Not Processed; 1 = Posted; 2 = No Intransit | |
LOT_COSTED_IND | NUMBER | (5) | Identifies if transaction was processed by Lot Actual Cost. 0 = Not Processed; Null = Processed |
Cut, paste (and edit) the following text to query this object:
SELECT TRANS_ID
, ITEM_ID
, LINE_ID
, CO_CODE
, ORGN_CODE
, WHSE_CODE
, LOT_ID
, LOCATION
, DOC_ID
, DOC_TYPE
, DOC_LINE
, LINE_TYPE
, REASON_CODE
, CREATION_DATE
, TRANS_DATE
, TRANS_QTY
, TRANS_QTY2
, QC_GRADE
, LOT_STATUS
, TRANS_STAT
, TRANS_UM
, TRANS_UM2
, OP_CODE
, COMPLETED_IND
, STAGED_IND
, GL_POSTED_IND
, EVENT_ID
, DELETE_MARK
, TEXT_CODE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, REVERSE_ID
, PICK_SLIP_NUMBER
, MVT_STAT_STATUS
, MOVEMENT_ID
, LINE_DETAIL_ID
, INVOICED_FLAG
, INTORDER_POSTED_IND
, LOT_COSTED_IND
FROM GMI.IC_TRAN_PND;
GMI.IC_TRAN_PND does not reference any database object
GMI.IC_TRAN_PND is referenced by following:
|
|
|