Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Plan items source view |
Implementation/DBA Data: | APPS.MRP_ITEM_SOURCING_V |
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