APPS.JAI_RCV_OPM_COSTING_PKG dependencies on JAI_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 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: