[Home] [Help] [Dependency Information]
Object Name: | RCV_OPSM_LOT_SERIAL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.RCV_OPSM_LOT_SERIAL_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIPMENT_HEADER_ID | NUMBER | Yes | ||
SHIPMENT_LINE_ID | NUMBER | Yes | ||
GROUP_ID | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
PARENT_LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_NUM | VARCHAR2 | (80) | Yes | |
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
LOTQTY | NUMBER | Yes | ||
LOTQTYUOM | VARCHAR2 | (3) | ||
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
QC_GRADE | VARCHAR2 | (150) | ||
REASON_CODE | VARCHAR2 | (4) | ||
ORIGINATION_DATE | DATE | |||
BEST_BY_DATE | DATE | |||
RETEST_DATE | DATE | |||
EXPIRATION_DATE | DATE | |||
SERIAL_NUM | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, GROUP_ID
, TRANSACTION_ID
, PARENT_LOT_NUMBER
, LOT_NUM
, ORGANIZATION_CODE
, LOTQTY
, LOTQTYUOM
, PRIMARY_QUANTITY
, PRIMARY_UOM_CODE
, SECONDARY_QUANTITY
, SECONDARY_UOM_CODE
, QC_GRADE
, REASON_CODE
, ORIGINATION_DATE
, BEST_BY_DATE
, RETEST_DATE
, EXPIRATION_DATE
, SERIAL_NUM
FROM APPS.RCV_OPSM_LOT_SERIAL_V;
|
|
|