eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MRP_PO_SUPPLY_VIEW

Object Details

Object Name:	MRP_PO_SUPPLY_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_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	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	MPS, MRP or DRP plan identifier
MPS_ORGANIZATION_ID	NUMBER		MPS organization identifier
ORGANIZATION_ID	NUMBER		Organization identifier
SUPPLY_HEADER_ID	NUMBER		Supply header identifier
VENDOR_ID	NUMBER		Supplier identifier
SUPPLY_TYPE	NUMBER		Supply type
MPS_DELIVERY_SCHEDULE_DATE	DATE		MPS delivery schedule date
DELIVERY_SCHEDULE_DATE	DATE		PO expected delivery date
MPS_SUPPLY_QUANTITY	NUMBER		MPS supply quantity
SUPPLY_QUANTITY	NUMBER		PO supply quantity
MPS_SUPPLY_SCRAP_QUANTITY	NUMBER		MPS supply scrap quantity
SUPPLY_SCRAP_QUANTITY	NUMBER		PO supply scrap quantity
SUPPLY_DELIVERY_BALANCE	NUMBER		Supply delivery balance
SUPPLY_UNIT_PRICE	NUMBER		Supply unit price
SUPPLY_STATUS	NUMBER		Supply status
SUPPLY_LINE_NUM	NUMBER		PO line number
SUPPLY_FIRM_PLANNED_STATUS	NUMBER		Whether PO was firmed or not
DOCK_DATE	DATE		Expected receipt date
SUPPLY_NUMBER	VARCHAR2	(62)	Supply number
REVISION_NUM	VARCHAR2	(3)	Revision number
PRINTED_DATE	DATE		Printed date
UOM_CODE	VARCHAR2	(3)	Unit of measure
SUPPLY_LINE_ID	NUMBER		Supply line identifier
MRP_DESTINATION_TYPE_CODE	VARCHAR2	(25)	MRP destination type
DESTINATION_TYPE_CODE	VARCHAR2	(25)	Destination type
PROJECT_ID	NUMBER		Project identifier
TASK_ID	NUMBER		Task identifier
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	Unit number
TO_SUBINVENTORY	VARCHAR2	(10)	Value specified in PO
VENDOR_SITE_ID	NUMBER		Supplier site identifier
FROM_ORGANIZATION_ID	NUMBER		From Organiztion Id

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      COMPILE_DESIGNATOR
,      MPS_ORGANIZATION_ID
,      ORGANIZATION_ID
,      SUPPLY_HEADER_ID
,      VENDOR_ID
,      SUPPLY_TYPE
,      MPS_DELIVERY_SCHEDULE_DATE
,      DELIVERY_SCHEDULE_DATE
,      MPS_SUPPLY_QUANTITY
,      SUPPLY_QUANTITY
,      MPS_SUPPLY_SCRAP_QUANTITY
,      SUPPLY_SCRAP_QUANTITY
,      SUPPLY_DELIVERY_BALANCE
,      SUPPLY_UNIT_PRICE
,      SUPPLY_STATUS
,      SUPPLY_LINE_NUM
,      SUPPLY_FIRM_PLANNED_STATUS
,      DOCK_DATE
,      SUPPLY_NUMBER
,      REVISION_NUM
,      PRINTED_DATE
,      UOM_CODE
,      SUPPLY_LINE_ID
,      MRP_DESTINATION_TYPE_CODE
,      DESTINATION_TYPE_CODE
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      TO_SUBINVENTORY
,      VENDOR_SITE_ID
,      FROM_ORGANIZATION_ID
FROM APPS.MRP_PO_SUPPLY_VIEW;

Dependencies

[top of page]

APPS.MRP_PO_SUPPLY_VIEW references the following:

APPS: AP_SUPPLIER_SITES_ALL; FND_PROFILE - show dependent code; MRP_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; OE_DROP_SHIP_SOURCES; PO_PO_SUPPLY_VIEW; PO_RCV_SUPPLY_VIEW; PO_REQ_SUPPLY_VIEW; PO_SHIP_RCV_SUPPLY_VIEW; PO_SHIP_SUPPLY_VIEW; PO_UNITEFF_PKG - show dependent code; PO_VENDORS_VIEW

APPS.MRP_PO_SUPPLY_VIEW is not referenced by any database object