APPS.CSTPACWS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 175: from mtl_material_transactions

171: /* Added for bug 3715567 */
172: stmt_num := 95;
173: select transaction_date
174: into i_txn_date
175: from mtl_material_transactions
176: where transaction_id = i_trx_id;
177:
178: stmt_num := 98;
179: /* Get the value of Include Component yield flag, which will determine

Line 196: FROM mtl_material_transactions

192:
193: BEGIN
194: SELECT nvl(sum(primary_quantity),0)
195: INTO l_future_issued_qty
196: FROM mtl_material_transactions
197: WHERE organization_id = wro_rec.organization_id
198: AND inventory_item_id = wro_rec.inventory_item_id
199: AND operation_seq_num = wro_rec.operation_seq_num
200: AND transaction_source_id = wro_rec.wip_entity_id

Line 206: from mtl_material_transactions

202: (transaction_date = i_txn_date and transaction_id > i_trx_id) )
203: AND costed_flag IS NOT NULL
204: AND nvl(move_transaction_id,-999) <>
205: ( Select nvl(move_transaction_id,-999)
206: from mtl_material_transactions
207: where transaction_id = i_trx_id);
208: EXCEPTION
209: WHEN Others THEN
210: l_future_issued_qty := 0;