DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2808: from mtl_material_transactions

2804: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2805:
2806: cursor C_QUANTITY is
2807: select transaction_quantity
2808: from mtl_material_transactions
2809: where transaction_id = p_transaction_id;
2810:
2811: BEGIN
2812:

Line 2896: from mtl_material_transactions

2892: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2893:
2894: cursor C_QUANTITY is
2895: select transaction_quantity
2896: from mtl_material_transactions
2897: where transaction_id = p_transaction_id;
2898:
2899: BEGIN
2900: x_return_status := l_fnd_success;

Line 3028: mtl_material_transactions mmt

3024: mtl_unit_transactions mut,
3025: mtl_secondary_inventories msi,
3026: hr_all_organization_units haou,
3027: rcv_transactions rt,
3028: mtl_material_transactions mmt
3029: WHERE
3030: mmt.transaction_id = p_transaction_id AND
3031: mmt.inventory_item_id = msib.inventory_item_id AND
3032: mmt.organization_id = msib.organization_id AND

Line 3094: mtl_material_transactions mmt

3090: mtl_transaction_lot_numbers mtln,
3091: mtl_secondary_inventories msi,
3092: hr_all_organization_units haou,
3093: rcv_transactions rt,
3094: mtl_material_transactions mmt
3095: WHERE
3096: mmt.transaction_id = p_transaction_id AND
3097: mmt.inventory_item_id = msib.inventory_item_id AND
3098: mmt.organization_id = msib.organization_id AND

Line 3742: FROM mtl_material_transactions

3738: l_inv_name VARCHAR2(30);
3739:
3740: CURSOR x is
3741: SELECT transaction_type_id
3742: FROM mtl_material_transactions
3743: WHERE transaction_id = p_transaction_id;
3744:
3745: BEGIN
3746:

Line 4113: FROM mtl_material_transactions

4109: transaction_action_id,
4110: transaction_type_id,
4111: transaction_source_type_id,
4112: ship_to_location_id
4113: FROM mtl_material_transactions
4114: WHERE transaction_id = p_transaction_id;
4115:
4116: r_mtl_data c_mtl_data%rowtype;
4117: