VIEW: APPS.MRP_SC_BILL_MAKE_AT_V

Source

View Text - Preformatted

SELECT /* INDEX(SR MRP_SOURCING_RULES_U1) */ sources.allocation_percent || '% Make at ' || param1.organization_code , SOURCES.ASSIGNMENT_SET_ID , SOURCES.ASSIGNMENT_TYPE , SOURCES.SOURCING_RULE_NAME , SOURCES.ORGANIZATION_ID , PARAM1.ORGANIZATION_CODE , SOURCES.INVENTORY_ITEM_ID , KFV1.CONCATENATED_SEGMENTS , SOURCES.SOURCE_ORGANIZATION_ID , PARAM2.ORGANIZATION_CODE , SOURCES.INVENTORY_ITEM_ID , KFV1.CONCATENATED_SEGMENTS , TO_NUMBER(NULL) , CAL.CALENDAR_DATE , SOURCES.ALLOCATION_PERCENT , SOURCES.RANK FROM MTL_PARAMETERS PARAM2, MTL_SYSTEM_ITEMS_KFV KFV1, BOM_CALENDAR_DATES CAL, MTL_PARAMETERS PARAM1, MRP_SOURCES_V SOURCES WHERE PARAM2.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID AND KFV1.ORGANIZATION_ID = SOURCES.ORGANIZATION_ID AND KFV1.INVENTORY_ITEM_ID = SOURCES.INVENTORY_ITEM_ID AND CAL.CALENDAR_CODE = PARAM1.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = PARAM1.CALENDAR_EXCEPTION_SET_ID AND CAL.CALENDAR_DATE BETWEEN SOURCES.EFFECTIVE_DATE AND NVL(SOURCES.DISABLE_DATE, TO_DATE(2634525, 'J')) AND PARAM1.ORGANIZATION_ID = SOURCES.ORGANIZATION_ID AND SOURCES.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID

View Text - HTML Formatted

SELECT /* INDEX(SR MRP_SOURCING_RULES_U1) */ SOURCES.ALLOCATION_PERCENT || '% MAKE AT ' || PARAM1.ORGANIZATION_CODE
, SOURCES.ASSIGNMENT_SET_ID
, SOURCES.ASSIGNMENT_TYPE
, SOURCES.SOURCING_RULE_NAME
, SOURCES.ORGANIZATION_ID
, PARAM1.ORGANIZATION_CODE
, SOURCES.INVENTORY_ITEM_ID
, KFV1.CONCATENATED_SEGMENTS
, SOURCES.SOURCE_ORGANIZATION_ID
, PARAM2.ORGANIZATION_CODE
, SOURCES.INVENTORY_ITEM_ID
, KFV1.CONCATENATED_SEGMENTS
, TO_NUMBER(NULL)
, CAL.CALENDAR_DATE
, SOURCES.ALLOCATION_PERCENT
, SOURCES.RANK
FROM MTL_PARAMETERS PARAM2
, MTL_SYSTEM_ITEMS_KFV KFV1
, BOM_CALENDAR_DATES CAL
, MTL_PARAMETERS PARAM1
, MRP_SOURCES_V SOURCES
WHERE PARAM2.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID
AND KFV1.ORGANIZATION_ID = SOURCES.ORGANIZATION_ID
AND KFV1.INVENTORY_ITEM_ID = SOURCES.INVENTORY_ITEM_ID
AND CAL.CALENDAR_CODE = PARAM1.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PARAM1.CALENDAR_EXCEPTION_SET_ID
AND CAL.CALENDAR_DATE BETWEEN SOURCES.EFFECTIVE_DATE
AND NVL(SOURCES.DISABLE_DATE
, TO_DATE(2634525
, 'J'))
AND PARAM1.ORGANIZATION_ID = SOURCES.ORGANIZATION_ID
AND SOURCES.ORGANIZATION_ID = SOURCES.SOURCE_ORGANIZATION_ID