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


VIEW: APPS.PO_RCV_SUPPLY_VIEW

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

Inventory item identifier
ORGANIZATION_ID NUMBER

Destination organization identifier
PO_HEADER_ID NUMBER

Purchase Order header identifier
VENDOR_ID NUMBER

Vendor identifier
VENDOR_SITE_ID NUMBER

DOCK_DATE DATE
Yes Receipt date
PO_NUMBER VARCHAR2 (62)
Purchase Order number
RCV_TRX_QUANTITY NUMBER
Yes Quantity in the receiving transaction unit of measure
RCV_TRX_UOM_CODE VARCHAR2 (3) Yes Receiving transaction unit of measure
PRIMARY_UOM_QUANTITY NUMBER

Quantity in the primary unit of measure of item
PRIMARY_UOM VARCHAR2 (25)
Primary unit of measure of item
UNIT_PRICE NUMBER

Price per item
LINE_NUM NUMBER
Yes Purchase Order line number
DESTINATION_TYPE_CODE VARCHAR2 (25) Yes Destination type
RECEIVING_DOCUMENT_DESIGNATOR VARCHAR2 (30)
Receipt number
PO_REVISION_NUM NUMBER

Purchase Order revision number
MRP_EXPECTED_DELIVERY_DATE DATE

MRP expected delivery date
MRP_PRIMARY_QUANTITY NUMBER

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

MRP destination organization identifier
MRP_TO_SUBINVENTORY VARCHAR2 (10)
MRP destination subinventory identifier
PO_LINE_ID NUMBER

Purchase Order line identifier
ITEM_REVISION VARCHAR2 (3)
EXPECTED_DELIVERY_DATE DATE

TO_ORG_PRIMARY_QUANTITY NUMBER

TO_ORGANIZATION_ID NUMBER

PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Task Identifier
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
,      PO_HEADER_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      DOCK_DATE
,      PO_NUMBER
,      RCV_TRX_QUANTITY
,      RCV_TRX_UOM_CODE
,      PRIMARY_UOM_QUANTITY
,      PRIMARY_UOM
,      UNIT_PRICE
,      LINE_NUM
,      DESTINATION_TYPE_CODE
,      RECEIVING_DOCUMENT_DESIGNATOR
,      PO_REVISION_NUM
,      MRP_EXPECTED_DELIVERY_DATE
,      MRP_PRIMARY_QUANTITY
,      MRP_PRIMARY_UOM
,      MRP_DESTINATION_TYPE_CODE
,      MRP_TO_ORGANIZATION_ID
,      MRP_TO_SUBINVENTORY
,      PO_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_RCV_SUPPLY_VIEW;

Dependencies

[top of page]

APPS.PO_RCV_SUPPLY_VIEW references the following:

SchemaAPPS
SynonymMTL_SUPPLY
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_TRANSACTIONS
APPS.PO_RCV_SUPPLY_VIEW is referenced by following:

SchemaAPPS
Package BodyGMPMPACT - show dependent code
ViewMRP_PO_SUPPLY_VIEW