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.

[Home] [Help]

View: MRP_SOURCES_V

Product:	MRP - Master Scheduling/MRP
Description:	Inventory item source view
Implementation/DBA Data:	APPS.MRP_SOURCES_V

View Text

SELECT MISLV. INVENTORY_ITEM_ID
, MISLV.ORGANIZATION_ID
, MISLV.ASSIGNMENT_TYPE
, MAS.ASSIGNMENT_SET_ID
, MISLV.SOURCING_RULE_TYPE
, MISLV.SOURCE_ORGANIZATION_ID
, MISLV.VENDOR_ID
, MISLV.VENDOR_SITE_ID
, MISLV.ALLOCATION_PERCENT
, MISLV.RANK
, MISLV.AVG_TRANSIT_LEAD_TIME
, MISLV.SHIP_METHOD
, MISLV.EFFECTIVE_DATE
, MISLV.DISABLE_DATE
, MISLV.CATEGORY_ID
, MISLV.ASSIGNMENT_ID
, MISLV.SOURCING_RULE_ID
, MISLV.SOURCE_TYPE
, MISLV.SOURCING_RULE_NAME
, MISLV.CUSTOMER_ID
, MISLV.SHIP_TO_SITE_ID
, MISLV.TIME_UOM_CODE
FROM MRP_ITEM_SOURCING_LEVELS_V MISLV
, MRP_ASSIGNMENT_SETS MAS
WHERE MISLV.SOURCING_LEVEL = (SELECT MIN(SOURCING_LEVEL)
FROM MRP_ITEM_SOURCING_LEVELS_V MISLV1
WHERE MISLV.ORGANIZATION_ID = MISLV1.ORGANIZATION_ID
AND MISLV.INVENTORY_ITEM_ID = MISLV1.INVENTORY_ITEM_ID
AND MAS.ASSIGNMENT_SET_ID = MISLV1.ASSIGNMENT_SET_ID )
AND MAS.ASSIGNMENT_SET_ID = MISLV.ASSIGNMENT_SET_ID

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
ASSIGNMENT_TYPE
ASSIGNMENT_SET_ID
SOURCING_RULE_TYPE
SOURCE_ORGANIZATION_ID
VENDOR_ID
VENDOR_SITE_ID
ALLOCATION_PERCENT
RANK
AVG_TRANSIT_LEAD_TIME
SHIP_METHOD
EFFECTIVE_DATE
DISABLE_DATE
CATEGORY_ID
ASSIGNMENT_ID
SOURCING_RULE_ID
SOURCE_TYPE
SOURCING_RULE_NAME
CUSTOMER_ID
SHIP_TO_SITE_ID
TIME_UOM_CODE