View: MRPBV_PLAN_ITEM_SOURCES

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_PLAN_ITEM_SOURCES

View Text

SELECT DISTINCT ORG.ORGANIZATION_CODE
, ALLORG.NAME
, SRC.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:ITEM'
, '_LA:SRC.ASSIGNMENT_TYPE:MFG_LOOKUPS:MRP_SR_ASSIGNMENT_TYPE:MEANING'
, '_LA:SRC.SOURCE_TYPE:MFG_LOOKUPS:MRP_SOURCE_TYPE:MEANING'
, SOURCE_ORG.ORGANIZATION_CODE
, ALLORG2.NAME
, VEN.VENDOR_NAME
, SITE.VENDOR_SITE_CODE
, SRC.EFFECTIVE_DATE
, SRC.DISABLE_DATE
, SRC.ALLOCATION_PERCENT
, SRC.RANK
, SRC.QUANTITY
, SRC.SHIP_METHOD
, SRC.AVG_TRANSIT_LEAD_TIME
, SRC.ORGANIZATION_ID
, SRC.INVENTORY_ITEM_ID
, SRC.SOURCE_ORGANIZATION_ID
, DECODE(RULE.SOURCING_RULE_TYPE
, 1
, SRC.SOURCING_RULE_ID
, NULL)
, DECODE(RULE.SOURCING_RULE_TYPE
, 2
, SRC.SOURCING_RULE_ID
, NULL)
, SRC.VENDOR_ID
, SRC.VENDOR_SITE_ID
, SRC.ASSIGNMENT_ID
, SRC.ASSIGNMENT_SET_ID
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATED_BY
, SRC.CREATION_DATE
, SRC.CREATED_BY
FROM MRP_PLANS PLAN
, MRP_PLAN_ORGANIZATIONS PLANORG
, MTL_SYSTEM_ITEMS ITEM
, HR_ALL_ORGANIZATION_UNITS ALLORG
, MTL_PARAMETERS ORG
, HR_ALL_ORGANIZATION_UNITS ALLORG2
, MTL_PARAMETERS SOURCE_ORG
, PO_VENDORS VEN
, PO_VENDOR_SITES SITE
, MRP_SOURCING_RULES RULE
, MRP_ITEM_SOURCING SRC
WHERE RULE.SOURCING_RULE_ID(+) = SRC.SOURCING_RULE_ID
AND SITE.VENDOR_SITE_ID(+) = SRC.VENDOR_SITE_ID
AND VEN.VENDOR_ID(+) = SRC.VENDOR_ID
AND SOURCE_ORG.ORGANIZATION_ID(+) = SRC.SOURCE_ORGANIZATION_ID
AND ALLORG2.ORGANIZATION_ID(+) = SRC.SOURCE_ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = SRC.ORGANIZATION_ID
AND ALLORG.ORGANIZATION_ID = SRC.ORGANIZATION_ID
AND ITEM.ORGANIZATION_ID = SRC.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = SRC.INVENTORY_ITEM_ID
AND PLANORG.PLAN_LEVEL(+) = 2
AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR
AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID
AND SRC.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR
AND SRC.ORGANIZATION_ID = NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID)
AND '_SEC:SRC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns