[Home] [Help] [Dependency Information]
Object Name: | PO_SHIP_RCV_SUPPLY_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_SHIP_RCV_SUPPLY_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | Item Identifier | ||
ORGANIZATION_ID | NUMBER | Receiving Organization identifier | ||
SHIPMENT_HEADER_ID | NUMBER | Shipment header identifier | ||
DOCK_DATE | DATE | Yes | Date of receipt | |
SHIPMENT_NUM | VARCHAR2 | (30) | Shipment number | |
RCV_TRX_QUANTITY | NUMBER | Transaction quantity | ||
RCV_TRX_UOM_CODE | VARCHAR2 | (3) | Yes | Transaction unit of measure |
PRIMARY_UOM_QUANTITY | NUMBER | Transaction quantity in the primary unit of measure of the item | ||
PRIMARY_UOM | VARCHAR2 | (25) | Primary unit of measure of the item | |
SHIPMENT_LINE_NUM | NUMBER | Yes | Shipment Line Number | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Yes | Destination type |
MRP_EXPECTED_DELIVERY_DATE | DATE | MRP expected delivery date | ||
MRP_PRIMARY_QUANTITY | NUMBER | MRP processed quantity in primary unit of measure of the item | ||
MRP_PRIMARY_UOM | VARCHAR2 | (25) | MRP processed primary unit of measure | |
MRP_DESTINATION_TYPE_CODE | VARCHAR2 | (25) | MRP destination type | |
MRP_TO_ORGANIZATION_ID | NUMBER | MRP destination organization | ||
MRP_TO_SUBINVENTORY | VARCHAR2 | (10) | MRP destination subinventory | |
SHIPMENT_LINE_ID | NUMBER | Shipment Line identifier | ||
ITEM_REVISION | VARCHAR2 | (3) | ||
EXPECTED_DELIVERY_DATE | DATE | |||
TO_ORG_PRIMARY_QUANTITY | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | Project Identifier (number) | ||
TASK_ID | NUMBER | Task Identifier (number) | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
TO_SUBINVENTORY | VARCHAR2 | (10) | ||
FROM_ORGANIZATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, ORGANIZATION_ID
, SHIPMENT_HEADER_ID
, DOCK_DATE
, SHIPMENT_NUM
, RCV_TRX_QUANTITY
, RCV_TRX_UOM_CODE
, PRIMARY_UOM_QUANTITY
, PRIMARY_UOM
, SHIPMENT_LINE_NUM
, DESTINATION_TYPE_CODE
, MRP_EXPECTED_DELIVERY_DATE
, MRP_PRIMARY_QUANTITY
, MRP_PRIMARY_UOM
, MRP_DESTINATION_TYPE_CODE
, MRP_TO_ORGANIZATION_ID
, MRP_TO_SUBINVENTORY
, SHIPMENT_LINE_ID
, ITEM_REVISION
, EXPECTED_DELIVERY_DATE
, TO_ORG_PRIMARY_QUANTITY
, TO_ORGANIZATION_ID
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, TO_SUBINVENTORY
, FROM_ORGANIZATION_ID
FROM APPS.PO_SHIP_RCV_SUPPLY_VIEW;
|
|
|