[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_LINES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_CMN_LINES |
Subobject Name: | |
Status: | VALID |
Stores the ASBN information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_CMN_LINES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CMN_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CMN_LINE_ID | NUMBER | Yes | Indicates the line Identifier.It derives its value based on a sequence. | |
SHIPMENT_NUMBER | VARCHAR2 | (30) | Indicates the shipment number of the ASBN Shipment. | |
PO_HEADER_ID | NUMBER | Indicates the Header Identifier of the purchase order based on which the ASBN is created. | ||
PO_LINE_ID | NUMBER | Indicates the Line Identifier of the Purchase order Line. | ||
PO_LINE_LOCATION_ID | NUMBER | Indicates the Purchase order line location identifier. | ||
PO_NUMBER | VARCHAR2 | (20) | Indicates the Purchase Order Number that was included in the ASBN Shipment. | |
LINE_NUM | NUMBER | Indicates the Line number of the purchase order. | ||
SHIPMENT_LINE_NUM | NUMBER | Indicates the Shipment line number of the purchase order line. | ||
HEADER_INTERFACE_ID | NUMBER | Indicates the Header identifier of the record created in the rcv_headers_interface. | ||
SHIPMENT_HEADER_ID | NUMBER | Indicates the Header identifier of the receipt created. | ||
INTERFACE_TRANSACTION_ID | NUMBER | Indicates the transaction identifier of the lines that are inserted in the rcv_transactions_interface table. | ||
SHIPMENT_LINE_ID | NUMBER | Indicates the Line Identifier of the receipt Line. | ||
ITEM_ID | NUMBER | Indicates the identifier of the Inventory Item. | ||
QUANTITY | NUMBER | Indicates the Quantiy for the inventory item in the ASBN shipment line. | ||
EXCISE_INV_NUMBER | VARCHAR2 | (30) | Indicates the Excise invoice number provided by the user. | |
EXCISE_INV_DATE | DATE | Indicated the Excise Invoice Date provide by the user. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Indicates the currency of the Purchase Order. | |
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 | |
PO_UNIT_PRICE | NUMBER | Indicates the Unit price of the Inventory Item in the Purchase Order. | ||
UOM_CODE | VARCHAR2 | (3) | Indicates the unit of measurement of the Inventory Item for the quantity in the ASBN Shipment. | |
OBJECT_VERSION_NUMBER | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT CMN_LINE_ID
, SHIPMENT_NUMBER
, PO_HEADER_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_NUMBER
, LINE_NUM
, SHIPMENT_LINE_NUM
, HEADER_INTERFACE_ID
, SHIPMENT_HEADER_ID
, INTERFACE_TRANSACTION_ID
, SHIPMENT_LINE_ID
, ITEM_ID
, QUANTITY
, EXCISE_INV_NUMBER
, EXCISE_INV_DATE
, CURRENCY_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PO_UNIT_PRICE
, UOM_CODE
, OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_LINES;
JA.JAI_CMN_LINES does not reference any database object
JA.JAI_CMN_LINES is referenced by following:
|
|
|