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 368: FROM mtl_material_transactions

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

Line 458: FROM mtl_material_transactions

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

Line 565: mtl_material_transactions mmt

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

Line 596: mtl_material_transactions mmt

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

Line 626: mtl_material_transactions mmt

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

Line 3846: FROM mtl_material_transactions

3842: INTO x_mtl_trx_type.transaction_id,
3843: x_mtl_trx_type.transaction_date,
3844: x_mtl_trx_type.transaction_type_id,
3845: x_mtl_trx_type.source_line_id
3846: FROM mtl_material_transactions
3847: WHERE transaction_id = p_transaction_id;
3848:
3849: EXCEPTION
3850: WHEN no_data_found THEN