eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_GROSS_REQ_COST_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_GROSS_REQ_COST_V

View Text

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)

Columns

Name
DEMAND_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
INVENTORY_ITEM_ID
ORGANIZATION_ID
COMPILE_DESIGNATOR
USING_ASSEMBLY_ITEM_ID
USING_ASSEMBLY_DEMAND_DATE
USING_REQUIREMENTS_QUANTITY
ASSEMBLY_DEMAND_COMP_DATE
DEMAND_TYPE
ORIGINATION_TYPE
DISPOSITION_ID
DAILY_DEMAND_RATE
REQUEST_ID
RESERVE_QUANTITY
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
SOURCE_ORGANIZATION_ID
RESERVATION_ID
UPDATED
STATUS
APPLIED
DEMAND_CLASS
FIRM_QUANTITY
FIRM_DATE
OLD_DEMAND_QUANTITY
OLD_DEMAND_DATE
DEMAND_SCHEDULE_NAME
PROJECT_ID
TASK_ID
PLANNING_GROUP
ITEM_COST