APPS.JAI_RCV_OPM_COSTING_PKG dependencies on RCV_TRANSACTIONS

Line 38: FROM jai_rcv_transactions

34: WHERE mtl.organization_id = jcio.organization_id
35: AND mtl.process_enabled_flag = 'Y'
36: )
37: AND EXISTS ( SELECT 1
38: FROM jai_rcv_transactions
39: WHERE shipment_header_id = rsl.shipment_header_id
40: AND shipment_line_id = rsl.shipment_line_id
41: AND transaction_type = lv_deliver_trx
42: );

Line 47: FROM jai_rcv_transactions jrcv

43:
44: CURSOR cur_rcv_costing_records(cp_shipment_line_id IN NUMBER )
45: IS
46: SELECT *
47: FROM jai_rcv_transactions jrcv
48: WHERE shipment_line_id = cp_shipment_line_id
49: AND ( (transaction_type IN (lv_deliver_trx,lv_rtr_trx))
50: OR (transaction_type = lv_correct_trx AND
51: parent_transaction_type IN (lv_rtr_trx,lv_deliver_trx)) )

Line 202: UPDATE rcv_transactions

198: ln_costing_amount := round((ln_costing_amount * ln_apportion_factor)/ABS(rcv_costing_records.quantity),5);
199:
200: IF ln_costing_amount IS NOT NULL THEN
201:
202: UPDATE rcv_transactions
203: SET po_unit_price = po_unit_price + ln_costing_amount
204: WHERE transaction_id = rcv_costing_records.transaction_id;
205:
206: UPDATE mtl_material_transactions

Line 210: UPDATE jai_rcv_transactions

206: UPDATE mtl_material_transactions
207: SET transaction_cost = transaction_cost + ln_costing_amount
208: WHERE rcv_transaction_id = rcv_costing_records.transaction_id;
209:
210: UPDATE jai_rcv_transactions
211: SET opm_costing_flag = 'Y',
212: opm_costing_amount = ln_costing_amount
213: WHERE transaction_id = rcv_costing_records.transaction_id;
214: