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


VIEW: APPS.PO_PO_SUPPLY_VIEW

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

EXPECTED_DOCK_DATE DATE

Expected receipt date
PO_NUMBER VARCHAR2 (62)
Purchase Order number
QUANTITY NUMBER
Yes Quantity in the Purchase Order unit of measure
PO_UOM_CODE VARCHAR2 (3) Yes Purchase Order unit of measure
PRIMARY_UOM_QUANTITY NUMBER

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

Price per item
LINE_NUM NUMBER
Yes Purchase Order line number
DESTINATION_TYPE_CODE VARCHAR2 (25) Yes Destination type
PRINTED_DATE DATE

Purchase Order firm date
PO_REVISION_NUM NUMBER

Purchase Order revision number
FIRM_PLANNED_STATUS_FLAG VARCHAR2 (25)
Indicates whether the Purchase Order was firmed or not
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 of the item
MRP_DESTINATION_TYPE_CODE VARCHAR2 (25)
MRP destination type
MRP_TO_ORGANIZATION_ID NUMBER

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

Purchase Order line identifier
PO_LINE_LOCATION_ID NUMBER

Purchase Order line location identifier
PO_DISTRIBUTION_ID NUMBER

Purchase Order distribution 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)
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
,      EXPECTED_DOCK_DATE
,      PO_NUMBER
,      QUANTITY
,      PO_UOM_CODE
,      PRIMARY_UOM_QUANTITY
,      PRIMARY_UOM
,      UNIT_PRICE
,      LINE_NUM
,      DESTINATION_TYPE_CODE
,      PRINTED_DATE
,      PO_REVISION_NUM
,      FIRM_PLANNED_STATUS_FLAG
,      MRP_EXPECTED_DELIVERY_DATE
,      MRP_PRIMARY_QUANTITY
,      MRP_PRIMARY_UOM
,      MRP_DESTINATION_TYPE_CODE
,      MRP_TO_ORGANIZATION_ID
,      MRP_TO_SUBINVENTORY
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      ITEM_REVISION
,      EXPECTED_DELIVERY_DATE
,      TO_ORG_PRIMARY_QUANTITY
,      TO_ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      TO_SUBINVENTORY
FROM APPS.PO_PO_SUPPLY_VIEW;

Dependencies

[top of page]

APPS.PO_PO_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
APPS.PO_PO_SUPPLY_VIEW is referenced by following:

SchemaAPPS
Package BodyGMPMPACT - show dependent code
Package BodyGMPMRACT - show dependent code
ViewMRP_PO_SUPPLY_VIEW