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.CSTPPWMX dependencies on CST_ITEM_COSTS

Line 48: FROM cst_item_costs cic, mtl_parameters mp

44: FROM mtl_material_txn_allocations mmta
45: WHERE mmta.transaction_id = i_txn_id)
46: AND EXISTS
47: (SELECT 'Check if the item has cost'
48: FROM cst_item_costs cic, mtl_parameters mp
49: WHERE cic.inventory_item_id = i_item_id
50: AND mp.organization_id = i_org_id
51: AND cic.organization_id = mp.cost_organization_id
52: AND cic.cost_type_id = i_cost_type_id)

Line 134: FROM cst_item_costs cic, mtl_parameters mp

130: l_round_unit) * l_round_unit),
131: nvl(b.pl_overhead_in,0) +
132: (ROUND((NVL(overhead_cost,0) * -1 * i_txn_qty) /
133: l_round_unit) * l_round_unit)
134: FROM cst_item_costs cic, mtl_parameters mp
135: WHERE cic.inventory_item_id = i_item_id
136: AND cic.organization_id = mp.cost_organization_id
137: AND mp.organization_id = i_org_id
138: AND cic.cost_type_id = i_cost_type_id

Line 145: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP

141: AND organization_id = i_org_id
142: AND wip_entity_id = i_entity_id
143: AND EXISTS
144: (SELECT 'Check if the item has cost'
145: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP
146: WHERE CIC.INVENTORY_ITEM_ID = i_item_id
147: AND CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
148: AND MP.ORGANIZATION_ID = i_org_id
149: AND CIC.COST_TYPE_ID = i_cost_type_id);

Line 186: FROM cst_item_costs cic,

182: alloc.primary_quantity)/l_round_unit)* l_round_unit,
183: nvl(b.pl_overhead_in,0) +
184: ROUND((NVL(overhead_cost,0) * -1 * alloc.primary_quantity)/
185: l_round_unit) * l_round_unit
186: FROM cst_item_costs cic,
187: mtl_parameters mp,
188: mtl_material_txn_allocations alloc
189: WHERE NVL(alloc.repetitive_schedule_id, -99) =
190: NVL(b.repetitive_schedule_id, -99)

Line 208: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP

204: FROM mtl_material_txn_allocations
205: WHERE transaction_id = i_txn_id)
206: AND EXISTS
207: (SELECT 'Check if the item has cost'
208: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP
209: WHERE INVENTORY_ITEM_ID = i_item_id
210: AND MP.ORGANIZATION_ID = i_org_id
211: AND CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
212: AND COST_TYPE_ID = i_cost_type_id);*/

Line 298: FROM cst_item_costs cic, mtl_parameters mp

294: FROM mtl_material_txn_allocations mmta
295: WHERE mmta.transaction_id = i_txn_id)
296: AND EXISTS
297: (SELECT 'Check if the item has cost'
298: FROM cst_item_costs cic, mtl_parameters mp
299: WHERE cic.inventory_item_id = i_item_id
300: AND mp.organization_id = i_org_id
301: AND cic.organization_id = mp.cost_organization_id
302: AND cic.cost_type_id = i_cost_type_id)

Line 467: FROM cst_item_costs cic , mtl_parameters mp

463: /l_round_unit)*l_round_unit,
464: 0)
465:
466:
467: FROM cst_item_costs cic , mtl_parameters mp
468: WHERE cic.inventory_item_id = i_item_id
469: AND cic.organization_id = mp.cost_organization_id
470: AND mp.organization_id = i_org_id
471: AND cic.cost_type_id = 1

Line 478: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP

474: AND b.organization_id = i_org_id
475: AND b.wip_entity_id = i_entity_id
476: AND EXISTS
477: (SELECT 'Check if the item has cost'
478: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP
479: WHERE INVENTORY_ITEM_ID = i_item_id
480: AND MP.ORGANIZATION_ID = i_org_id
481: AND CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
482: AND COST_TYPE_ID = i_cost_type_id);

Line 532: FROM cst_item_costs cic,

528: /l_round_unit)* l_round_unit,
529: nvl(b.tl_overhead_out,0) +
530: ROUND((NVL(tl_overhead,0) * alloc.primary_quantity)/
531: l_round_unit)* l_round_unit
532: FROM cst_item_costs cic,
533: mtl_parameters mp,
534: mtl_material_txn_allocations alloc
535: WHERE cic.inventory_item_id = i_item_id
536: AND cic.organization_id = mp.cost_organization_id

Line 554: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP

550: FROM mtl_material_txn_allocations
551: WHERE transaction_id = i_txn_id)
552: AND EXISTS
553: (SELECT 'Check if the item has cost'
554: FROM CST_ITEM_COSTS CIC, MTL_PARAMETERS MP
555: WHERE INVENTORY_ITEM_ID = i_item_id
556: AND MP.ORGANIZATION_ID = i_org_id
557: AND CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
558: AND COST_TYPE_ID = i_cost_type_id);*/