DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_SHIP_RCV_SUPPLY_VIEW

Object Details
Object Name: PO_SHIP_RCV_SUPPLY_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_SHIP_RCV_SUPPLY_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.PO_SHIP_RCV_SUPPLY_VIEW references the following:

SchemaAPPS
SynonymMTL_SUPPLY
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
PL/SQL PackagePO_UNITEFF_PKG - show dependent code
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS
APPS.PO_SHIP_RCV_SUPPLY_VIEW is referenced by following:

SchemaAPPS
Package BodyGMPMPACT - show dependent code
ViewMRP_PO_SUPPLY_VIEW