VIEW: APPS.MSC_SC_BILL_MAKE_AT_V

Source

View Text - Preformatted

SELECT sources.allocation_percent || '% '|| msc_get_name.lookup_meaning('MRP_SOURCE_TYPE',2)||' ' || PT1.organization_code , PT1.SR_INSTANCE_ID , SOURCES.ASSIGNMENT_SET_ID , SOURCES.ASSIGNMENT_TYPE , SOURCES.SOURCING_RULE_NAME , SOURCES.ORGANIZATION_ID , PT1.ORGANIZATION_CODE , SOURCES.INVENTORY_ITEM_ID , ITEM.ITEM_NAME , SOURCES.SOURCE_ORGANIZATION_ID , PT2.ORGANIZATION_CODE , SOURCES.INVENTORY_ITEM_ID , ITEM.ITEM_NAME , TO_NUMBER(NULL) , CAL.CALENDAR_DATE , SOURCES.ALLOCATION_PERCENT , SOURCES.RANK ,pt1.modeled_supplier_id, pt1.modeled_supplier_site_id FROM MSC_TRADING_PARTNERS PT2, MSC_ITEMS ITEM, MSC_CALENDAR_DATES CAL, MSC_TRADING_PARTNERS PT1, MSC_SOURCES_V SOURCES WHERE PT2.SR_TP_ID = SOURCES.SOURCE_ORGANIZATION_ID AND PT2.SR_INSTANCE_ID = SOURCES.SR_INSTANCE_ID AND PT2.PARTNER_TYPE = 3 AND ITEM.INVENTORY_ITEM_ID = SOURCES.INVENTORY_ITEM_ID AND CAL.CALENDAR_CODE = PT1.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = PT1.CALENDAR_EXCEPTION_SET_ID AND CAL.SR_INSTANCE_ID = PT1.SR_INSTANCE_ID AND CAL.CALENDAR_DATE BETWEEN SOURCES.EFFECTIVE_DATE AND NVL(SOURCES.DISABLE_DATE, TO_DATE(2634525, 'J')) AND PT1.SR_TP_ID = SOURCES.ORGANIZATION_ID AND PT1.SR_INSTANCE_ID = SOURCES.SR_INSTANCE_ID AND PT1.PARTNER_TYPE = 3 AND SOURCES.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID

View Text - HTML Formatted

SELECT SOURCES.ALLOCATION_PERCENT || '% '|| MSC_GET_NAME.LOOKUP_MEANING('MRP_SOURCE_TYPE'
, 2)||' ' || PT1.ORGANIZATION_CODE
, PT1.SR_INSTANCE_ID
, SOURCES.ASSIGNMENT_SET_ID
, SOURCES.ASSIGNMENT_TYPE
, SOURCES.SOURCING_RULE_NAME
, SOURCES.ORGANIZATION_ID
, PT1.ORGANIZATION_CODE
, SOURCES.INVENTORY_ITEM_ID
, ITEM.ITEM_NAME
, SOURCES.SOURCE_ORGANIZATION_ID
, PT2.ORGANIZATION_CODE
, SOURCES.INVENTORY_ITEM_ID
, ITEM.ITEM_NAME
, TO_NUMBER(NULL)
, CAL.CALENDAR_DATE
, SOURCES.ALLOCATION_PERCENT
, SOURCES.RANK
, PT1.MODELED_SUPPLIER_ID
, PT1.MODELED_SUPPLIER_SITE_ID
FROM MSC_TRADING_PARTNERS PT2
, MSC_ITEMS ITEM
, MSC_CALENDAR_DATES CAL
, MSC_TRADING_PARTNERS PT1
, MSC_SOURCES_V SOURCES
WHERE PT2.SR_TP_ID = SOURCES.SOURCE_ORGANIZATION_ID
AND PT2.SR_INSTANCE_ID = SOURCES.SR_INSTANCE_ID
AND PT2.PARTNER_TYPE = 3
AND ITEM.INVENTORY_ITEM_ID = SOURCES.INVENTORY_ITEM_ID
AND CAL.CALENDAR_CODE = PT1.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PT1.CALENDAR_EXCEPTION_SET_ID
AND CAL.SR_INSTANCE_ID = PT1.SR_INSTANCE_ID
AND CAL.CALENDAR_DATE BETWEEN SOURCES.EFFECTIVE_DATE
AND NVL(SOURCES.DISABLE_DATE
, TO_DATE(2634525
, 'J'))
AND PT1.SR_TP_ID = SOURCES.ORGANIZATION_ID
AND PT1.SR_INSTANCE_ID = SOURCES.SR_INSTANCE_ID
AND PT1.PARTNER_TYPE = 3
AND SOURCES.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID