APPS.CSTPPWMX dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 44: FROM mtl_material_txn_allocations mmta

40: AND wpb.organization_id = i_org_id
41: AND wpb.wip_entity_id = i_entity_id
42: AND wpb.repetitive_schedule_id in
43: (SELECT mmta.repetitive_schedule_id
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

Line 188: mtl_material_txn_allocations alloc

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)
191: AND alloc.transaction_id = i_txn_id
192: AND cic.inventory_item_id = i_item_id

Line 204: FROM mtl_material_txn_allocations

200: AND organization_id = i_org_id
201: AND wip_entity_id = i_entity_id
202: AND repetitive_schedule_id in
203: (SELECT repetitive_schedule_id
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

Line 294: FROM mtl_material_txn_allocations mmta

290: AND wpb.organization_id = i_org_id
291: AND wpb.wip_entity_id = i_entity_id
292: AND wpb.repetitive_schedule_id in
293: (SELECT mmta.repetitive_schedule_id
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

Line 534: mtl_material_txn_allocations alloc

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
537: AND mp.organization_id = i_org_id
538: AND cic.cost_type_id = 1

Line 550: FROM mtl_material_txn_allocations

546: AND b.organization_id = i_org_id
547: AND b.wip_entity_id = i_entity_id
548: AND b.repetitive_schedule_id in
549: (SELECT repetitive_schedule_id
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