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.

APPS.CST_INVENTORY_PVT dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 3589: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,

3585: OVER (PARTITION BY MMT.transaction_id) outside_processing_cost,
3586: SUM(DECODE(mcacd.cost_element_id,5,nvl(mcacd.actual_cost,0),0))
3587: OVER (PARTITION BY MMT.transaction_id) overhead_cost,
3588: NVL(MCACD.creation_date,MMT.creation_date) txn_date
3589: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
3590: mtl_material_transactions mmt
3591: WHERE MCACD.ORGANIZATION_ID(+) = p_organization_id
3592: AND MCACD.inventory_item_id(+) = p_inventory_item_id
3593: AND MMT.transaction_date > p_valuation_date

Line 4405: from mtl_cst_actual_cost_details MCACD,

4401: ),
4402: SUM(
4403: DECODE(MCACD.cost_element_id,5,NVL(MCACD.prior_cost,0),0)
4404: )
4405: from mtl_cst_actual_cost_details MCACD,
4406: cst_quantity_layers CQL,
4407: ( select organization_id,
4408: inventory_item_id,
4409: cost_group_id,

Line 4472: MTL_CST_ACTUAL_COST_DETAILS MCACD

4468: from mtl_interorg_parameters
4469: where from_organization_id = p_organization_id
4470: or to_organization_id = p_organization_id) MIP,
4471: MTL_MATERIAL_TRANSACTIONS MMT,
4472: MTL_CST_ACTUAL_COST_DETAILS MCACD
4473: where ( ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,
4474: CST_Inventory_PVT.g_run_onhand_date),
4475: MMT.creation_date)
4476: AND MMT.transaction_action_id = 21

Line 4510: MTL_CST_ACTUAL_COST_DETAILS MCACD

4506: MCACD.layer_id,
4507: MMT.inventory_item_id,
4508: MCACD.organization_id
4509: from MTL_MATERIAL_TRANSACTIONS MMT,
4510: MTL_CST_ACTUAL_COST_DETAILS MCACD
4511: where MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
4512: AND MMT.costed_flag is null
4513: AND MMT.transaction_action_id not in (5,30,40,41,42,43,50,51,52,11,17,10,13,9,14,7,26,36,25,56,57)
4514: AND NOT (MMT.transaction_action_id IN (2,28,55) AND MMT.primary_quantity > 0)

Line 4574: FROM mtl_cst_actual_cost_details MCACD2

4570: /* Only take action 2 for the common issue/return to wip */
4571: AND NOT ( MCACD.transaction_action_id in (1,27)
4572: AND MCACD.layer_id = CQL.layer_id
4573: AND EXISTS ( SELECT 'restrict wip component issue action'
4574: FROM mtl_cst_actual_cost_details MCACD2
4575: WHERE MCACD2.transaction_id = MCACD.transaction_id
4576: AND MCACD2.layer_id = MCACD.layer_id
4577: AND MCACD2.transaction_action_id = 2
4578: )