[Home] [Help] [Dependency Information]
Object Name: | PMITS_INV_LINE_SUMM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_INV_LINE_SUMM_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_ID | NUMBER | (10) | Document ID | |
JOIN_DOC_ID | NUMBER | This will have actual Document id for XFER,TRNI,TRNR,MTRI | ||
DOC_TYPE | VARCHAR2 | (4) | Documnet Type | |
LINE_ID | NUMBER | (10) | Detail Line Identifier | |
ITEM_ID | NUMBER | (10) | Item Identifier | |
COMPANY_CODE | VARCHAR2 | (4) | Company Code | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
TRANSACTION_DATE | VARCHAR2 | (4000) | Transaction Date | |
LOT_ID | VARCHAR2 | (40) | Lot Identifier | |
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NUMBER | VARCHAR2 | (32) | Sublot Number | |
LOT_STATUS | VARCHAR2 | (4) | Lot Status | |
QUALITY_CONTROL_GRADE | VARCHAR2 | (4) | Quality Control Grade | |
REASON_CODE | VARCHAR2 | (4) | Reason Code | |
TRANSACTION_UOM | VARCHAR2 | (4) | Transaction UOM | |
TRANSACTION_SECONDARY_UOM | VARCHAR2 | (4) | Transaction Secondary UOM | |
TRANSACTION_QTY | NUMBER | Transaction Quantity | ||
TRANSACTION_QTY2 | NUMBER | Transaction Quantity in Secondary UOM | ||
TRANS_TYPE | CHAR | (8) | Transaction Type. This column is used to join subsidiary ledger data with inventory data |
Cut, paste (and edit) the following text to query this object:
SELECT DOC_ID
, JOIN_DOC_ID
, DOC_TYPE
, LINE_ID
, ITEM_ID
, COMPANY_CODE
, ORGANIZATION_CODE
, WAREHOUSE_CODE
, LOCATION
, TRANSACTION_DATE
, LOT_ID
, LOT_NUMBER
, SUBLOT_NUMBER
, LOT_STATUS
, QUALITY_CONTROL_GRADE
, REASON_CODE
, TRANSACTION_UOM
, TRANSACTION_SECONDARY_UOM
, TRANSACTION_QTY
, TRANSACTION_QTY2
, TRANS_TYPE
FROM APPS.PMITS_INV_LINE_SUMM_V;
APPS.PMITS_INV_LINE_SUMM_V is not referenced by any database object
|
|
|