SELECT segs.CONCATENATED_SEGMENTS || '/' || param.organization_code , SETS.ASSIGNMENT_SET_ID , SEGS.INVENTORY_ITEM_ID , SEGS.CONCATENATED_SEGMENTS , PARAM.ORGANIZATION_ID , PARAM.ORGANIZATION_CODE , CAL.CALENDAR_DATE FROM MRP_ASSIGNMENT_SETS SETS, BOM_CALENDAR_DATES CAL, MTL_SYSTEM_ITEMS_KFV SEGS, MTL_PARAMETERS PARAM WHERE CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID AND SEGS.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
SELECT SEGS.CONCATENATED_SEGMENTS || '/' || PARAM.ORGANIZATION_CODE
, SETS.ASSIGNMENT_SET_ID
, SEGS.INVENTORY_ITEM_ID
, SEGS.CONCATENATED_SEGMENTS
, PARAM.ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, CAL.CALENDAR_DATE
FROM MRP_ASSIGNMENT_SETS SETS
, BOM_CALENDAR_DATES CAL
, MTL_SYSTEM_ITEMS_KFV SEGS
, MTL_PARAMETERS PARAM
WHERE CAL.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND SEGS.ORGANIZATION_ID = PARAM.ORGANIZATION_ID
|
|
|