APPS.CSI_INV_TXN_HOOK_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 70: FROM mtl_material_transactions

66: ship_to_location_id,
67: organization_id,
68: transaction_id,
69: parent_transaction_id
70: FROM mtl_material_transactions
71: WHERE transaction_id = p_transaction_id;
72:
73: r_mtl_data c_mtl_data%rowtype;
74:

Line 85: mtl_material_transactions mmt

81:
82: CURSOR c_wip_entity_type is
83: SELECT entity_type
84: FROM wip_entities we,
85: mtl_material_transactions mmt
86: WHERE mmt.transaction_source_id=we.wip_entity_id
87: AND mmt.transaction_id= p_transaction_id;
88:
89: r_type_class c_type_class%rowtype;

Line 94: FROM mtl_material_transactions

90: l_wip_entity_type wip_entities.entity_type%type;
91:
92: CURSOR c_parent_org (pc_par_txn_id IN NUMBER) is
93: SELECT organization_id
94: FROM mtl_material_transactions
95: WHERE transaction_id = pc_par_txn_id;
96:
97: CURSOR c_ic_shipment (pc_parent_org IN NUMBER,pc_transaction_id IN NUMBER) is
98: SELECT transaction_id

Line 99: FROM mtl_material_transactions

95: WHERE transaction_id = pc_par_txn_id;
96:
97: CURSOR c_ic_shipment (pc_parent_org IN NUMBER,pc_transaction_id IN NUMBER) is
98: SELECT transaction_id
99: FROM mtl_material_transactions
100: WHERE transaction_id = pc_transaction_id
101: AND organization_id = pc_parent_org;
102:
103: BEGIN