DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 272: from JAI_RCV_TRANSACTIONS

268: transaction_date,
269: parent_transaction_id,
270: inventory_item_id,
271: inv_item_flag /* Service */
272: from JAI_RCV_TRANSACTIONS
273: where transaction_id = cp_transaction_id;
274:
275: cursor c_rcv_transactions(cp_transaction_id in number) is
276: select shipment_header_id,

Line 1861: update JAI_RCV_TRANSACTIONS

1857: /* If apply relieve BOE has been done successfully, update the boe_applied_flag in ja_in_rcv_transaction */
1858: if p_process_flag = 'Y' and nvl(p_simulation , 'Y') <> 'Y' then
1859:
1860: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1861: update JAI_RCV_TRANSACTIONS
1862: set boe_applied_flag = 'Y'
1863: where transaction_id = p_transaction_id;
1864:
1865: end if;