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


VIEW: APPS.PO_SHIP_SUPPLY_VIEW

Object Details
Object Name: PO_SHIP_SUPPLY_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_SHIP_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

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
SHIPMENT_HEADER_ID NUMBER

Shipment header identifier
DOCK_DATE DATE

Expected receipt date of the shipment
SHIPMENT_HEADER_NUM VARCHAR2 (30)
Shipment header number
SHIPMENT_QUANTITY NUMBER

Quantity in the shipment unit of measure
SHIPMENT_UOM_CODE VARCHAR2 (3)
Shipment unit of measure
PRIMARY_QUANTITY NUMBER

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

Shipment line number
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type
MRP_EXPECTED_DELIVERY_DATE DATE

MRP's expected delivery date
MRP_PRIMARY_QUANTITY NUMBER

MRP quantity in the primary unit of measure
MRP_PRIMARY_UOM VARCHAR2 (25)
MRP primary unit of measure of item
MRP_DESTINATION_TYPE_CODE VARCHAR2 (25)
MRP destination type
MRP_TO_ORGANIZATION_ID NUMBER

MRP destination organization identifier
MRP_TO_SUBINVENTORY VARCHAR2 (10)
MRP destination subinventory identifier
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_HEADER_NUM
,      SHIPMENT_QUANTITY
,      SHIPMENT_UOM_CODE
,      PRIMARY_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_SUPPLY_VIEW;

Dependencies

[top of page]

APPS.PO_SHIP_SUPPLY_VIEW references the following:

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

SchemaAPPS
Package BodyGMPMPACT - show dependent code
ViewMRP_PO_SUPPLY_VIEW