APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 347: from JAI_RCV_TRANSACTIONS

343: transaction_date,
344: parent_transaction_id,
345: inventory_item_id,
346: inv_item_flag /* Service */
347: from JAI_RCV_TRANSACTIONS
348: where transaction_id = cp_transaction_id;
349:
350: cursor c_rcv_transactions(cp_transaction_id in number) is
351: select shipment_header_id,

Line 1416: from JAI_RCV_TRANSACTIONS

1412: transaction_date,
1413: parent_transaction_id,
1414: inventory_item_id,
1415: inv_item_flag /* Service */
1416: from JAI_RCV_TRANSACTIONS
1417: where transaction_id = cp_transaction_id;
1418:
1419: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
1420:

Line 2189: update JAI_RCV_TRANSACTIONS

2185: /* If apply relieve BOE has been done successfully, update the boe_applied_flag in ja_in_rcv_transaction */
2186: if p_process_flag = 'Y' and nvl(p_simulation , 'Y') <> 'Y' then
2187:
2188: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2189: update JAI_RCV_TRANSACTIONS
2190: set boe_applied_flag = 'Y'
2191: where transaction_id = p_transaction_id;
2192:
2193: end if;

Line 3065: from JAI_RCV_TRANSACTIONS

3061: ------------------------------------------------------------------
3062: select organization_id,
3063: location_id
3064: into ln_organization_id,ln_location_id
3065: from JAI_RCV_TRANSACTIONS
3066: where transaction_id = p_transaction_id;
3067:
3068:
3069: