APPS.CSI_INV_TRXS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3214: from mtl_material_transactions

3210: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3211:
3212: cursor C_QUANTITY is
3213: select transaction_quantity
3214: from mtl_material_transactions
3215: where transaction_id = p_transaction_id;
3216:
3217: BEGIN
3218:

Line 3302: from mtl_material_transactions

3298: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3299:
3300: cursor C_QUANTITY is
3301: select transaction_quantity
3302: from mtl_material_transactions
3303: where transaction_id = p_transaction_id;
3304:
3305: BEGIN
3306: x_return_status := l_fnd_success;

Line 3434: mtl_material_transactions mmt

3430: mtl_unit_transactions mut,
3431: mtl_secondary_inventories msi,
3432: hr_all_organization_units haou,
3433: rcv_transactions rt,
3434: mtl_material_transactions mmt
3435: WHERE
3436: mmt.transaction_id = p_transaction_id AND
3437: mmt.inventory_item_id = msib.inventory_item_id AND
3438: mmt.organization_id = msib.organization_id AND

Line 3500: mtl_material_transactions mmt

3496: mtl_transaction_lot_numbers mtln,
3497: mtl_secondary_inventories msi,
3498: hr_all_organization_units haou,
3499: rcv_transactions rt,
3500: mtl_material_transactions mmt
3501: WHERE
3502: mmt.transaction_id = p_transaction_id AND
3503: mmt.inventory_item_id = msib.inventory_item_id AND
3504: mmt.organization_id = msib.organization_id AND

Line 3653: mtl_material_transactions mmt

3649: mtl_unit_transactions mut,
3650: mtl_secondary_inventories msi,
3651: hr_all_organization_units haou,
3652: rcv_transactions rt,
3653: mtl_material_transactions mmt
3654: WHERE
3655: mmt.transaction_id = p_transaction_id AND
3656: mmt.inventory_item_id = msib.inventory_item_id AND
3657: mmt.organization_id = msib.organization_id AND

Line 3721: mtl_material_transactions mmt

3717: mtl_transaction_lot_numbers mtln,
3718: mtl_secondary_inventories msi,
3719: hr_all_organization_units haou,
3720: rcv_transactions rt,
3721: mtl_material_transactions mmt
3722: WHERE
3723: mmt.transaction_id = p_transaction_id AND
3724: mmt.inventory_item_id = msib.inventory_item_id AND
3725: mmt.organization_id = msib.organization_id AND

Line 4387: FROM mtl_material_transactions

4383: l_inv_name VARCHAR2(30);
4384:
4385: CURSOR x is
4386: SELECT transaction_type_id
4387: FROM mtl_material_transactions
4388: WHERE transaction_id = p_transaction_id;
4389:
4390: BEGIN
4391:

Line 4778: FROM mtl_material_transactions

4774: transaction_action_id,
4775: transaction_type_id,
4776: transaction_source_type_id,
4777: ship_to_location_id
4778: FROM mtl_material_transactions
4779: WHERE transaction_id = p_transaction_id;
4780:
4781: r_mtl_data c_mtl_data%rowtype;
4782: