APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 279: FROM mtl_material_transactions

275: SELECT inventory_item_id,
276: organization_id
277: INTO l_item_control_rec.inventory_item_id,
278: l_item_control_rec.organization_id
279: FROM mtl_material_transactions
280: WHERE transaction_id = p_mtl_txn_id;
281:
282: EXCEPTION
283: WHEN no_data_found THEN

Line 367: FROM mtl_material_transactions

363: api_log('get_partner_order_info');
364:
365: SELECT trx_source_line_id
366: INTO l_rma_line_id
367: FROM mtl_material_transactions
368: WHERE transaction_id = p_mtl_txn_id;
369:
370: IF l_rma_line_id IS NOT NULL THEN
371:

Line 457: FROM mtl_material_transactions

453: x_src_order_rec.transaction_id := p_mtl_txn_id;
454:
455: SELECT trx_source_line_id
456: INTO x_src_order_rec.rma_line_id
457: FROM mtl_material_transactions
458: WHERE transaction_id = p_mtl_txn_id;
459:
460: SELECT nvl(reference_line_id , fnd_api.g_miss_num)
461: INTO x_src_order_rec.original_order_line_id

Line 564: mtl_material_transactions mmt

560: FROM hr_all_organization_units haou,
561: mtl_transaction_lot_numbers mtln,
562: mtl_unit_transactions mut,
563: mtl_secondary_inventories msi,
564: mtl_material_transactions mmt
565: WHERE mmt.transaction_id = p_mtl_txn_id
566: AND mmt.transaction_id = mut.transaction_id(+)
567: AND mmt.transaction_id = mtln.transaction_id(+)
568: AND mmt.subinventory_code = msi.secondary_inventory_name

Line 595: mtl_material_transactions mmt

591: FROM hr_all_organization_units haou,
592: mtl_transaction_lot_numbers mtln,
593: mtl_unit_transactions mut,
594: mtl_secondary_inventories msi,
595: mtl_material_transactions mmt
596: WHERE mmt.transaction_id = p_mtl_txn_id
597: AND mmt.subinventory_code = msi.secondary_inventory_name
598: AND mmt.organization_id = msi.organization_id
599: AND mtln.transaction_id = mmt.transaction_id

Line 625: mtl_material_transactions mmt

621: mmt.creation_date creation_date -- bug 4026148
622: FROM hr_all_organization_units haou,
623: mtl_transaction_lot_numbers mtln,
624: mtl_secondary_inventories msi,
625: mtl_material_transactions mmt
626: WHERE mmt.transaction_id = p_mtl_txn_id
627: AND mmt.transaction_id = mtln.transaction_id(+)
628: AND mmt.subinventory_code = msi.secondary_inventory_name
629: AND mmt.organization_id = msi.organization_id

Line 3807: FROM mtl_material_transactions

3803: INTO x_mtl_trx_type.transaction_id,
3804: x_mtl_trx_type.transaction_date,
3805: x_mtl_trx_type.transaction_type_id,
3806: x_mtl_trx_type.source_line_id
3807: FROM mtl_material_transactions
3808: WHERE transaction_id = p_transaction_id;
3809:
3810: EXCEPTION
3811: WHEN no_data_found THEN