VIEW: APPS.MRP_SC_BILL_BOM_V

Source

View Text - Preformatted

SELECT DISTINCT kfv1.CONCATENATED_SEGMENTS || '/' || param.organization_code , bic.COMPONENT_QUANTITY || 'x ' || kfv2.CONCATENATED_SEGMENTS || '/' || param.organization_code , SETS.ASSIGNMENT_SET_ID , PARAM.ORGANIZATION_ID , PARAM.ORGANIZATION_CODE , BBM.ASSEMBLY_ITEM_ID , KFV1.CONCATENATED_SEGMENTS , BIC.OPERATION_SEQ_NUM , BIC.COMPONENT_ITEM_ID , KFV2.CONCATENATED_SEGMENTS , CAL.CALENDAR_DATE , BIC.COMPONENT_QUANTITY FROM MTL_SYSTEM_ITEMS_KFV KFV2, MTL_SYSTEM_ITEMS_KFV KFV1, BOM_CALENDAR_DATES CAL, ENG_REVISED_ITEMS ERI, BOM_INVENTORY_COMPONENTS BIC, BOM_BILL_OF_MATERIALS BBM, MTL_PARAMETERS PARAM, MRP_ASSIGNMENT_SETS SETS WHERE KFV2.ORGANIZATION_ID = PARAM.ORGANIZATION_ID AND KFV2.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID AND KFV1.ORGANIZATION_ID = PARAM.ORGANIZATION_ID AND KFV1.INVENTORY_ITEM_ID = BBM.ASSEMBLY_ITEM_ID AND ERI.REVISED_ITEM_SEQUENCE_ID (+) = BIC.REVISED_ITEM_SEQUENCE_ID AND (NVL(ERI.MRP_ACTIVE, 1) != 2 OR DECODE(ERI.REVISED_ITEM_ID, NULL, SYSDATE, ERI.IMPLEMENTATION_DATE) IS NOT NULL) AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND CAL.CALENDAR_DATE BETWEEN BIC.EFFECTIVITY_DATE AND NVL(BIC.DISABLE_DATE, TO_DATE(2634525, 'J')) AND BIC.BILL_SEQUENCE_ID = BBM.COMMON_BILL_SEQUENCE_ID AND BBM.ORGANIZATION_ID = PARAM.ORGANIZATION_ID

View Text - HTML Formatted

SELECT DISTINCT KFV1.CONCATENATED_SEGMENTS || '/' || PARAM.ORGANIZATION_CODE
, BIC.COMPONENT_QUANTITY || 'X ' || KFV2.CONCATENATED_SEGMENTS || '/' || PARAM.ORGANIZATION_CODE
, SETS.ASSIGNMENT_SET_ID
, PARAM.ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, BBM.ASSEMBLY_ITEM_ID
, KFV1.CONCATENATED_SEGMENTS
, BIC.OPERATION_SEQ_NUM
, BIC.COMPONENT_ITEM_ID
, KFV2.CONCATENATED_SEGMENTS
, CAL.CALENDAR_DATE
, BIC.COMPONENT_QUANTITY
FROM MTL_SYSTEM_ITEMS_KFV KFV2
, MTL_SYSTEM_ITEMS_KFV KFV1
, BOM_CALENDAR_DATES CAL
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BBM
, MTL_PARAMETERS PARAM
, MRP_ASSIGNMENT_SETS SETS
WHERE KFV2.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
AND KFV2.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
AND KFV1.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
AND KFV1.INVENTORY_ITEM_ID = BBM.ASSEMBLY_ITEM_ID
AND ERI.REVISED_ITEM_SEQUENCE_ID (+) = BIC.REVISED_ITEM_SEQUENCE_ID
AND (NVL(ERI.MRP_ACTIVE
, 1) != 2 OR DECODE(ERI.REVISED_ITEM_ID
, NULL
, SYSDATE
, ERI.IMPLEMENTATION_DATE) IS NOT NULL)
AND CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL.CALENDAR_DATE BETWEEN BIC.EFFECTIVITY_DATE
AND NVL(BIC.DISABLE_DATE
, TO_DATE(2634525
, 'J'))
AND BIC.BILL_SEQUENCE_ID = BBM.COMMON_BILL_SEQUENCE_ID
AND BBM.ORGANIZATION_ID = PARAM.ORGANIZATION_ID