VIEW: APPS.MRP_ITEM_SOURCING_V

Source

View Text - Preformatted

SELECT SRC.COMPILE_DESIGNATOR , ORGS.ORGANIZATION_ID , SRC.INVENTORY_ITEM_ID , ITEM.CONCATENATED_SEGMENTS , SRC.ORGANIZATION_ID , ORG.ORGANIZATION_CODE , SRC.SOURCE_ORGANIZATION_ID , SOURCE_ORG.ORGANIZATION_CODE , SRC.VENDOR_ID , VEN.VENDOR_NAME , SRC.VENDOR_SITE_ID , SITE.VENDOR_SITE_CODE , SRC.EFFECTIVE_DATE , SRC.LAST_UPDATED_BY , SRC.LAST_UPDATE_DATE , SRC.CREATED_BY , SRC.CREATION_DATE , SRC.LAST_UPDATE_LOGIN , SRC.DISABLE_DATE , SRC.ALLOCATION_PERCENT , SRC.RANK , SRC.QUANTITY , SRC.SOURCE_TYPE , L1.MEANING , SRC.AVG_TRANSIT_LEAD_TIME , SRC.SOURCING_RULE_ID , RULES.SOURCING_RULE_NAME , SRC.ASSIGNMENT_ID , SRC.ASSIGNMENT_SET_ID , SRC.ASSIGNMENT_TYPE , L3.MEANING , SRC.SOURCING_RULE_TYPE , L2.MEANING , SRC.SHIP_METHOD ,SRC.HISTORICAL_ALLOC_QTY FROM MFG_LOOKUPS L3, MFG_LOOKUPS L2, MRP_SOURCING_RULES RULES, MFG_LOOKUPS L1, PO_VENDOR_SITES SITE, PO_VENDORS VEN, MTL_PARAMETERS SOURCE_ORG, MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM, MRP_ITEM_SOURCING SRC, MRP_PLAN_ORGANIZATIONS_V ORGS WHERE L3.LOOKUP_TYPE(+) = 'MRP_SOURCE_TYPE' AND L3.LOOKUP_CODE(+) = SRC.SOURCE_TYPE AND L2.LOOKUP_TYPE(+) = 'MRP_SR_ASSIGNMENT_TYPE' AND L2.LOOKUP_CODE(+) = SRC.ASSIGNMENT_TYPE AND RULES.SOURCING_RULE_ID(+) = SRC.SOURCING_RULE_ID AND L1.LOOKUP_TYPE(+) = 'MRP_SOURCING_RULE_TYPE' AND L1.LOOKUP_CODE(+) = SRC.SOURCING_RULE_TYPE 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 ORG.ORGANIZATION_ID = SRC.ORGANIZATION_ID AND ITEM.ORGANIZATION_ID = SRC.ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = SRC.INVENTORY_ITEM_ID AND SRC.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR AND SRC.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION

View Text - HTML Formatted

SELECT SRC.COMPILE_DESIGNATOR
, ORGS.ORGANIZATION_ID
, SRC.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, SRC.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, SRC.SOURCE_ORGANIZATION_ID
, SOURCE_ORG.ORGANIZATION_CODE
, SRC.VENDOR_ID
, VEN.VENDOR_NAME
, SRC.VENDOR_SITE_ID
, SITE.VENDOR_SITE_CODE
, SRC.EFFECTIVE_DATE
, SRC.LAST_UPDATED_BY
, SRC.LAST_UPDATE_DATE
, SRC.CREATED_BY
, SRC.CREATION_DATE
, SRC.LAST_UPDATE_LOGIN
, SRC.DISABLE_DATE
, SRC.ALLOCATION_PERCENT
, SRC.RANK
, SRC.QUANTITY
, SRC.SOURCE_TYPE
, L1.MEANING
, SRC.AVG_TRANSIT_LEAD_TIME
, SRC.SOURCING_RULE_ID
, RULES.SOURCING_RULE_NAME
, SRC.ASSIGNMENT_ID
, SRC.ASSIGNMENT_SET_ID
, SRC.ASSIGNMENT_TYPE
, L3.MEANING
, SRC.SOURCING_RULE_TYPE
, L2.MEANING
, SRC.SHIP_METHOD
, SRC.HISTORICAL_ALLOC_QTY
FROM MFG_LOOKUPS L3
, MFG_LOOKUPS L2
, MRP_SOURCING_RULES RULES
, MFG_LOOKUPS L1
, PO_VENDOR_SITES SITE
, PO_VENDORS VEN
, MTL_PARAMETERS SOURCE_ORG
, MTL_PARAMETERS ORG
, MTL_SYSTEM_ITEMS_KFV ITEM
, MRP_ITEM_SOURCING SRC
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE L3.LOOKUP_TYPE(+) = 'MRP_SOURCE_TYPE'
AND L3.LOOKUP_CODE(+) = SRC.SOURCE_TYPE
AND L2.LOOKUP_TYPE(+) = 'MRP_SR_ASSIGNMENT_TYPE'
AND L2.LOOKUP_CODE(+) = SRC.ASSIGNMENT_TYPE
AND RULES.SOURCING_RULE_ID(+) = SRC.SOURCING_RULE_ID
AND L1.LOOKUP_TYPE(+) = 'MRP_SOURCING_RULE_TYPE'
AND L1.LOOKUP_CODE(+) = SRC.SOURCING_RULE_TYPE
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 ORG.ORGANIZATION_ID = SRC.ORGANIZATION_ID
AND ITEM.ORGANIZATION_ID = SRC.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = SRC.INVENTORY_ITEM_ID
AND SRC.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR
AND SRC.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION