Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_ITEM_SOURCING_V |
SELECT SRC.PLAN_ID
, ORGS.ORGANIZATION_ID
, ORGS.SR_INSTANCE_ID
, SRC.INVENTORY_ITEM_ID
, ITEM.ITEM_NAME
, SRC.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(SRC.ORGANIZATION_ID
, SRC.SR_INSTANCE_ID)
, SRC.SOURCE_ORGANIZATION_ID
, SRC.SR_INSTANCE_ID2
, MSC_GET_NAME.ORG_CODE(SRC.SOURCE_ORGANIZATION_ID
, SRC.SR_INSTANCE_ID2)
, VEN.PARTNER_ID
, VEN.PARTNER_NAME
, SRC.SUPPLIER_SITE_ID
, SITE.TP_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.CONVERSION_FACTOR
, SRC.SOURCE_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_SOURCING_RULE_TYPE'
, SRC.SOURCING_RULE_TYPE)
, SRC.AVG_TRANSIT_LEAD_TIME
, SRC.SOURCING_RULE_ID
, RULES.SOURCING_RULE_NAME
, SRC.ASSIGNMENT_ID
, SRC.ASSIGNMENT_SET_ID
, SRC.ASSIGNMENT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_SOURCE_TYPE'
, SRC.SOURCE_TYPE)
, SRC.SOURCING_RULE_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_SR_ASSIGNMENT_TYPE'
, SRC.ASSIGNMENT_TYPE)
, SRC.SHIP_METHOD
, SRC.HISTORICAL_ALLOC_QTY
, SRC.SR_INSTANCE_ID
, CAT.CATEGORY_SET_ID
, CAT.SR_CATEGORY_ID
FROM MSC_SOURCING_RULES RULES
, MSC_TRADING_PARTNER_SITES SITE
, MSC_TRADING_PARTNERS VEN
, MSC_ITEMS ITEM
, MSC_ITEM_SOURCING SRC
, MSC_PLANS ORGS
, MSC_ITEM_CATEGORIES CAT
WHERE RULES.SOURCING_RULE_ID(+) = SRC.SOURCING_RULE_ID
AND SITE.PARTNER_SITE_ID(+) = SRC.SUPPLIER_SITE_ID
AND SITE.PARTNER_ID(+) = SRC.SUPPLIER_ID
AND SRC.SUPPLIER_ID = VEN.PARTNER_ID(+)
AND VEN.PARTNER_TYPE(+)=1
AND ITEM.INVENTORY_ITEM_ID = SRC.INVENTORY_ITEM_ID
AND SRC.PLAN_ID = ORGS.PLAN_ID
AND CAT.INVENTORY_ITEM_ID = SRC.INVENTORY_ITEM_ID
AND CAT.SR_INSTANCE_ID = SRC.SR_INSTANCE_ID
AND CAT.ORGANIZATION_ID = SRC.ORGANIZATION_ID