APPS.PJM_BORROW_PAYBACK dependencies on MTL_MATERIAL_TRANSACTIONS

Line 127: -- Fetch transaction details from MTL_MATERIAL_TRANSACTIONS

123:
124: BEGIN
125:
126: --
127: -- Fetch transaction details from MTL_MATERIAL_TRANSACTIONS
128: --
129: SELECT transaction_type_id
130: , primary_quantity * (-1)
131: , project_id

Line 147: FROM mtl_material_transactions

143: , L_to_task_id
144: , L_item_id
145: , L_revision
146: , L_organization_id
147: FROM mtl_material_transactions
148: WHERE transaction_id = X_transaction_id;
149:
150: --
151: -- Make sure this is a borrow or payback transaction

Line 176: FROM mtl_material_transactions_temp

172: if ( L_trx_type_id = 66 ) then
173:
174: SELECT scheduled_payback_date
175: INTO L_payback_date
176: FROM mtl_material_transactions_temp
177: WHERE transaction_temp_id = X_transaction_temp_id;
178:
179: INSERT INTO pjm_borrow_transactions
180: ( borrow_transaction_id

Line 222: FROM mtl_material_transactions

218: , (-1) * primary_quantity
219: , (-1) * primary_quantity
220: , transaction_date
221: , L_payback_date
222: FROM mtl_material_transactions
223: WHERE transaction_id = X_transaction_id;
224:
225: else
226:

Line 296: FROM mtl_material_transactions

292: , project_id
293: , decode(L_proj_ctrl_level, 2, task_id, NULL)
294: , to_project_id
295: , decode(L_proj_ctrl_level, 2, to_task_id, NULL)
296: FROM mtl_material_transactions
297: WHERE transaction_id = X_transaction_id;
298:
299: UPDATE pjm_borrow_transactions
300: SET outstanding_quantity = outstanding_quantity - L_payback_qty