VIEW: APPS.MRPBV_PLAN_ITEM_SOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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