APPS.CSTPPLLC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 42: FROM mtl_material_transactions mmt

38: repetitive_line_id,
39: inventory_item_id,
40: organization_id,
41: flow_schedule
42: FROM mtl_material_transactions mmt
43: WHERE transaction_source_type_id = 5 /* job or schedule */
44: AND transaction_action_id IN (30, 31, 32) /* scrap,completion,return */
45: AND transaction_date BETWEEN trunc(c_start_date)
46: AND (trunc(c_end_date) + 0.99999)

Line 140: FROM mtl_material_transactions mmt

136: comp_rec.inventory_item_id,
137: mmt.inventory_item_id,
138: 'N',
139: 1000
140: FROM mtl_material_transactions mmt
141: WHERE transaction_source_id = comp_rec.transaction_source_id
142: AND transaction_source_type_id = 5
143: AND transaction_action_id IN (1,27,33,34)
144: AND transaction_date BETWEEN trunc(i_start_date)

Line 202: FROM mtl_material_transactions mmt

198: comp_rec.inventory_item_id,
199: mmt.inventory_item_id,
200: 'N',
201: 1000
202: FROM mtl_material_transactions mmt
203: WHERE transaction_source_id = comp_rec.transaction_source_id
204: AND repetitive_line_id = comp_rec.repetitive_line_id
205: AND transaction_source_type_id = 5
206: AND transaction_action_id IN (1,27,33,34)

Line 241: FROM mtl_material_transactions mmt

237: comp_rec.inventory_item_id,
238: mmt.inventory_item_id,
239: 'N',
240: 1000
241: FROM mtl_material_transactions mmt
242: WHERE mmt.completion_transaction_id =
243: comp_rec.completion_transaction_id
244: AND transaction_date BETWEEN trunc(i_start_date)
245: AND (trunc(i_end_date) + 0.99999)

Line 270: FROM mtl_material_transactions mmt

266: comp_rec.inventory_item_id,
267: mmt.inventory_item_id,
268: 'N',
269: 1000
270: FROM mtl_material_transactions mmt
271: WHERE mmt.completion_transaction_id =
272: comp_rec.completion_transaction_id
273: AND transaction_date BETWEEN trunc(i_start_date)
274: AND (trunc(i_end_date) + 0.99999)

Line 360: mtl_material_transactions mmt1,

356: msik2.concatenated_segments component_item,
357: we.wip_entity_id wip_entity_id,
358: we.wip_entity_name wip_entity
359: FROM cst_pac_explosion_temp cpet,
360: mtl_material_transactions mmt1,
361: mtl_material_transactions mmt2,
362: mtl_system_items_kfv msik1,
363: mtl_system_items_kfv msik2,
364: wip_entities we

Line 361: mtl_material_transactions mmt2,

357: we.wip_entity_id wip_entity_id,
358: we.wip_entity_name wip_entity
359: FROM cst_pac_explosion_temp cpet,
360: mtl_material_transactions mmt1,
361: mtl_material_transactions mmt2,
362: mtl_system_items_kfv msik1,
363: mtl_system_items_kfv msik2,
364: wip_entities we
365: WHERE cpet.pac_period_id = c_pac_period_id