VIEW: APPS.MTL_GROSS_REQ_COST_V

Source

View Text - Preformatted

SELECT GROSS.DEMAND_ID , GROSS.LAST_UPDATE_DATE , GROSS.LAST_UPDATED_BY , GROSS.CREATION_DATE , GROSS.CREATED_BY , GROSS.LAST_UPDATE_LOGIN , GROSS.INVENTORY_ITEM_ID , GROSS.ORGANIZATION_ID , GROSS.COMPILE_DESIGNATOR , GROSS.USING_ASSEMBLY_ITEM_ID , GROSS.USING_ASSEMBLY_DEMAND_DATE , GROSS.USING_REQUIREMENTS_QUANTITY , GROSS.ASSEMBLY_DEMAND_COMP_DATE , GROSS.DEMAND_TYPE , GROSS.ORIGINATION_TYPE , GROSS.DISPOSITION_ID , GROSS.DAILY_DEMAND_RATE , GROSS.REQUEST_ID , GROSS.RESERVE_QUANTITY , GROSS.PROGRAM_APPLICATION_ID , GROSS.PROGRAM_ID , GROSS.PROGRAM_UPDATE_DATE , GROSS.SOURCE_ORGANIZATION_ID , GROSS.RESERVATION_ID , GROSS.UPDATED , GROSS.STATUS , GROSS.APPLIED , GROSS.DEMAND_CLASS , GROSS.FIRM_QUANTITY , GROSS.FIRM_DATE , GROSS.OLD_DEMAND_QUANTITY , GROSS.OLD_DEMAND_DATE , GROSS.DEMAND_SCHEDULE_NAME , GROSS.PROJECT_ID , GROSS.TASK_ID , GROSS.PLANNING_GROUP , CCICV.ITEM_COST FROM MRP_GROSS_REQUIREMENTS GROSS, CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE GROSS.PROJECT_ID IS NULL AND CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MP.DEFAULT_COST_GROUP_ID, 1)) UNION ALL SELECT GROSS.DEMAND_ID, GROSS.LAST_UPDATE_DATE, GROSS.LAST_UPDATED_BY, GROSS.CREATION_DATE, GROSS.CREATED_BY, GROSS.LAST_UPDATE_LOGIN, GROSS.INVENTORY_ITEM_ID, GROSS.ORGANIZATION_ID, GROSS.COMPILE_DESIGNATOR, GROSS.USING_ASSEMBLY_ITEM_ID , GROSS.USING_ASSEMBLY_DEMAND_DATE, GROSS.USING_REQUIREMENTS_QUANTITY , GROSS.ASSEMBLY_DEMAND_COMP_DATE , GROSS.DEMAND_TYPE , GROSS.ORIGINATION_TYPE , GROSS.DISPOSITION_ID , GROSS.DAILY_DEMAND_RATE , GROSS.REQUEST_ID , GROSS.RESERVE_QUANTITY , GROSS.PROGRAM_APPLICATION_ID, GROSS.PROGRAM_ID , GROSS.PROGRAM_UPDATE_DATE , GROSS.SOURCE_ORGANIZATION_ID, GROSS.RESERVATION_ID , GROSS.UPDATED , GROSS.STATUS , GROSS.APPLIED , GROSS.DEMAND_CLASS , GROSS.FIRM_QUANTITY , GROSS.FIRM_DATE , GROSS.OLD_DEMAND_QUANTITY , GROSS.OLD_DEMAND_DATE, GROSS.DEMAND_SCHEDULE_NAME, GROSS.PROJECT_ID, GROSS.TASK_ID, GROSS.PLANNING_GROUP, 0 FROM MRP_GROSS_REQUIREMENTS GROSS WHERE GROSS.PROJECT_ID IS NULL AND NOT EXISTS (SELECT 'x' FROM CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MP.DEFAULT_COST_GROUP_ID, 1))) UNION ALL SELECT GROSS.DEMAND_ID, GROSS.LAST_UPDATE_DATE, GROSS.LAST_UPDATED_BY, GROSS.CREATION_DATE, GROSS.CREATED_BY, GROSS.LAST_UPDATE_LOGIN, GROSS.INVENTORY_ITEM_ID, GROSS.ORGANIZATION_ID, GROSS.COMPILE_DESIGNATOR, GROSS.USING_ASSEMBLY_ITEM_ID , GROSS.USING_ASSEMBLY_DEMAND_DATE, GROSS.USING_REQUIREMENTS_QUANTITY , GROSS.ASSEMBLY_DEMAND_COMP_DATE , GROSS.DEMAND_TYPE , GROSS.ORIGINATION_TYPE , GROSS.DISPOSITION_ID , GROSS.DAILY_DEMAND_RATE , GROSS.REQUEST_ID , GROSS.RESERVE_QUANTITY , GROSS.PROGRAM_APPLICATION_ID, GROSS.PROGRAM_ID , GROSS.PROGRAM_UPDATE_DATE , GROSS.SOURCE_ORGANIZATION_ID, GROSS.RESERVATION_ID , GROSS.UPDATED , GROSS.STATUS , GROSS.APPLIED , GROSS.DEMAND_CLASS , GROSS.FIRM_QUANTITY , GROSS.FIRM_DATE , GROSS.OLD_DEMAND_QUANTITY , GROSS.OLD_DEMAND_DATE, GROSS.DEMAND_SCHEDULE_NAME, GROSS.PROJECT_ID, GROSS.TASK_ID, GROSS.PLANNING_GROUP, CCICV.ITEM_COST FROM MRP_GROSS_REQUIREMENTS GROSS, MRP_PROJECT_PARAMETERS MRP, CST_CG_ITEM_COSTS_VIEW CCICV WHERE GROSS.PROJECT_ID IS NOT NULL AND MRP.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND MRP.PROJECT_ID = GROSS.PROJECT_ID AND CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID UNION ALL SELECT GROSS.DEMAND_ID, GROSS.LAST_UPDATE_DATE, GROSS.LAST_UPDATED_BY, GROSS.CREATION_DATE, GROSS.CREATED_BY, GROSS.LAST_UPDATE_LOGIN, GROSS.INVENTORY_ITEM_ID, GROSS.ORGANIZATION_ID, GROSS.COMPILE_DESIGNATOR, GROSS.USING_ASSEMBLY_ITEM_ID , GROSS.USING_ASSEMBLY_DEMAND_DATE, GROSS.USING_REQUIREMENTS_QUANTITY , GROSS.ASSEMBLY_DEMAND_COMP_DATE , GROSS.DEMAND_TYPE , GROSS.ORIGINATION_TYPE , GROSS.DISPOSITION_ID , GROSS.DAILY_DEMAND_RATE , GROSS.REQUEST_ID , GROSS.RESERVE_QUANTITY , GROSS.PROGRAM_APPLICATION_ID, GROSS.PROGRAM_ID , GROSS.PROGRAM_UPDATE_DATE , GROSS.SOURCE_ORGANIZATION_ID, GROSS.RESERVATION_ID , GROSS.UPDATED , GROSS.STATUS , GROSS.APPLIED , GROSS.DEMAND_CLASS , GROSS.FIRM_QUANTITY , GROSS.FIRM_DATE , GROSS.OLD_DEMAND_QUANTITY , GROSS.OLD_DEMAND_DATE, GROSS.DEMAND_SCHEDULE_NAME, GROSS.PROJECT_ID, GROSS.TASK_ID, GROSS.PLANNING_GROUP, 0 FROM MRP_GROSS_REQUIREMENTS GROSS, MRP_PROJECT_PARAMETERS MRP WHERE GROSS.PROJECT_ID IS NOT NULL AND MRP.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND MRP.PROJECT_ID = GROSS.PROJECT_ID AND NOT EXISTS (SELECT 'x' FROM CST_CG_ITEM_COSTS_VIEW CCICV WHERE CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID)

View Text - HTML Formatted

SELECT GROSS.DEMAND_ID
, GROSS.LAST_UPDATE_DATE
, GROSS.LAST_UPDATED_BY
, GROSS.CREATION_DATE
, GROSS.CREATED_BY
, GROSS.LAST_UPDATE_LOGIN
, GROSS.INVENTORY_ITEM_ID
, GROSS.ORGANIZATION_ID
, GROSS.COMPILE_DESIGNATOR
, GROSS.USING_ASSEMBLY_ITEM_ID
, GROSS.USING_ASSEMBLY_DEMAND_DATE
, GROSS.USING_REQUIREMENTS_QUANTITY
, GROSS.ASSEMBLY_DEMAND_COMP_DATE
, GROSS.DEMAND_TYPE
, GROSS.ORIGINATION_TYPE
, GROSS.DISPOSITION_ID
, GROSS.DAILY_DEMAND_RATE
, GROSS.REQUEST_ID
, GROSS.RESERVE_QUANTITY
, GROSS.PROGRAM_APPLICATION_ID
, GROSS.PROGRAM_ID
, GROSS.PROGRAM_UPDATE_DATE
, GROSS.SOURCE_ORGANIZATION_ID
, GROSS.RESERVATION_ID
, GROSS.UPDATED
, GROSS.STATUS
, GROSS.APPLIED
, GROSS.DEMAND_CLASS
, GROSS.FIRM_QUANTITY
, GROSS.FIRM_DATE
, GROSS.OLD_DEMAND_QUANTITY
, GROSS.OLD_DEMAND_DATE
, GROSS.DEMAND_SCHEDULE_NAME
, GROSS.PROJECT_ID
, GROSS.TASK_ID
, GROSS.PLANNING_GROUP
, CCICV.ITEM_COST
FROM MRP_GROSS_REQUIREMENTS GROSS
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE GROSS.PROJECT_ID IS NULL
AND CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID
AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1)) UNION ALL SELECT GROSS.DEMAND_ID
, GROSS.LAST_UPDATE_DATE
, GROSS.LAST_UPDATED_BY
, GROSS.CREATION_DATE
, GROSS.CREATED_BY
, GROSS.LAST_UPDATE_LOGIN
, GROSS.INVENTORY_ITEM_ID
, GROSS.ORGANIZATION_ID
, GROSS.COMPILE_DESIGNATOR
, GROSS.USING_ASSEMBLY_ITEM_ID
, GROSS.USING_ASSEMBLY_DEMAND_DATE
, GROSS.USING_REQUIREMENTS_QUANTITY
, GROSS.ASSEMBLY_DEMAND_COMP_DATE
, GROSS.DEMAND_TYPE
, GROSS.ORIGINATION_TYPE
, GROSS.DISPOSITION_ID
, GROSS.DAILY_DEMAND_RATE
, GROSS.REQUEST_ID
, GROSS.RESERVE_QUANTITY
, GROSS.PROGRAM_APPLICATION_ID
, GROSS.PROGRAM_ID
, GROSS.PROGRAM_UPDATE_DATE
, GROSS.SOURCE_ORGANIZATION_ID
, GROSS.RESERVATION_ID
, GROSS.UPDATED
, GROSS.STATUS
, GROSS.APPLIED
, GROSS.DEMAND_CLASS
, GROSS.FIRM_QUANTITY
, GROSS.FIRM_DATE
, GROSS.OLD_DEMAND_QUANTITY
, GROSS.OLD_DEMAND_DATE
, GROSS.DEMAND_SCHEDULE_NAME
, GROSS.PROJECT_ID
, GROSS.TASK_ID
, GROSS.PLANNING_GROUP
, 0
FROM MRP_GROSS_REQUIREMENTS GROSS
WHERE GROSS.PROJECT_ID IS NULL
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID
AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1))) UNION ALL SELECT GROSS.DEMAND_ID
, GROSS.LAST_UPDATE_DATE
, GROSS.LAST_UPDATED_BY
, GROSS.CREATION_DATE
, GROSS.CREATED_BY
, GROSS.LAST_UPDATE_LOGIN
, GROSS.INVENTORY_ITEM_ID
, GROSS.ORGANIZATION_ID
, GROSS.COMPILE_DESIGNATOR
, GROSS.USING_ASSEMBLY_ITEM_ID
, GROSS.USING_ASSEMBLY_DEMAND_DATE
, GROSS.USING_REQUIREMENTS_QUANTITY
, GROSS.ASSEMBLY_DEMAND_COMP_DATE
, GROSS.DEMAND_TYPE
, GROSS.ORIGINATION_TYPE
, GROSS.DISPOSITION_ID
, GROSS.DAILY_DEMAND_RATE
, GROSS.REQUEST_ID
, GROSS.RESERVE_QUANTITY
, GROSS.PROGRAM_APPLICATION_ID
, GROSS.PROGRAM_ID
, GROSS.PROGRAM_UPDATE_DATE
, GROSS.SOURCE_ORGANIZATION_ID
, GROSS.RESERVATION_ID
, GROSS.UPDATED
, GROSS.STATUS
, GROSS.APPLIED
, GROSS.DEMAND_CLASS
, GROSS.FIRM_QUANTITY
, GROSS.FIRM_DATE
, GROSS.OLD_DEMAND_QUANTITY
, GROSS.OLD_DEMAND_DATE
, GROSS.DEMAND_SCHEDULE_NAME
, GROSS.PROJECT_ID
, GROSS.TASK_ID
, GROSS.PLANNING_GROUP
, CCICV.ITEM_COST
FROM MRP_GROSS_REQUIREMENTS GROSS
, MRP_PROJECT_PARAMETERS MRP
, CST_CG_ITEM_COSTS_VIEW CCICV
WHERE GROSS.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND MRP.PROJECT_ID = GROSS.PROJECT_ID
AND CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID UNION ALL SELECT GROSS.DEMAND_ID
, GROSS.LAST_UPDATE_DATE
, GROSS.LAST_UPDATED_BY
, GROSS.CREATION_DATE
, GROSS.CREATED_BY
, GROSS.LAST_UPDATE_LOGIN
, GROSS.INVENTORY_ITEM_ID
, GROSS.ORGANIZATION_ID
, GROSS.COMPILE_DESIGNATOR
, GROSS.USING_ASSEMBLY_ITEM_ID
, GROSS.USING_ASSEMBLY_DEMAND_DATE
, GROSS.USING_REQUIREMENTS_QUANTITY
, GROSS.ASSEMBLY_DEMAND_COMP_DATE
, GROSS.DEMAND_TYPE
, GROSS.ORIGINATION_TYPE
, GROSS.DISPOSITION_ID
, GROSS.DAILY_DEMAND_RATE
, GROSS.REQUEST_ID
, GROSS.RESERVE_QUANTITY
, GROSS.PROGRAM_APPLICATION_ID
, GROSS.PROGRAM_ID
, GROSS.PROGRAM_UPDATE_DATE
, GROSS.SOURCE_ORGANIZATION_ID
, GROSS.RESERVATION_ID
, GROSS.UPDATED
, GROSS.STATUS
, GROSS.APPLIED
, GROSS.DEMAND_CLASS
, GROSS.FIRM_QUANTITY
, GROSS.FIRM_DATE
, GROSS.OLD_DEMAND_QUANTITY
, GROSS.OLD_DEMAND_DATE
, GROSS.DEMAND_SCHEDULE_NAME
, GROSS.PROJECT_ID
, GROSS.TASK_ID
, GROSS.PLANNING_GROUP
, 0
FROM MRP_GROSS_REQUIREMENTS GROSS
, MRP_PROJECT_PARAMETERS MRP
WHERE GROSS.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND MRP.PROJECT_ID = GROSS.PROJECT_ID
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
WHERE CCICV.ORGANIZATION_ID = GROSS.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = GROSS.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID)