eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_TABLE_FUNCTIONS

Line 201: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching

197: INTO l_rt_row.transaction_id
198: FROM DUAL;
199:
200: -- Bug 4401341
201: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching
202: the value from rti table as lpn_id fetched from the cache table does not
203: have the value that is updated by Inventory.There may be other fields that
204: would have got updated.So fetching all the values directly from rti and then
205: use them to populate rcv_transactions table.

Line 207: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );

203: have the value that is updated by Inventory.There may be other fields that
204: would have got updated.So fetching all the values directly from rti and then
205: use them to populate rcv_transactions table.
206: */
207: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
208:
209: select *
210: into l_rti_row
211: from rcv_transactions_interface

Line 273: l_parent_row := RCV_TABLE_FUNCTIONS.get_rt_row_from_id( l_rti_row.parent_transaction_id );

269: l_rt_row.user_entered_flag := 'N';
270: l_rt_row.parent_transaction_id := p_receive_id;
271: END IF;
272: ELSIF p_transaction_type IN ('RETURN TO VENDOR','RETURN TO CUSTOMER') THEN
273: l_parent_row := RCV_TABLE_FUNCTIONS.get_rt_row_from_id( l_rti_row.parent_transaction_id );
274: IF l_parent_row.transaction_type = 'DELIVER' THEN
275: l_rt_row.parent_transaction_id := l_parent_row.parent_transaction_id;
276: l_use_ship_to_flag := 'Y';
277: END IF;

Line 404: /* Bug 5246147: Removed the function calls rcv_table_functions.get_fspa_row_from_org() and

400: -- Bug 6265149 : End
401:
402: IF l_rti_row.currency_code IS NULL THEN
403:
404: /* Bug 5246147: Removed the function calls rcv_table_functions.get_fspa_row_from_org() and
405: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and
406: added the following sql to get the currency_code */
407: select gsob.currency_code into
408: l_rt_row.currency_code

Line 405: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and

401:
402: IF l_rti_row.currency_code IS NULL THEN
403:
404: /* Bug 5246147: Removed the function calls rcv_table_functions.get_fspa_row_from_org() and
405: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and
406: added the following sql to get the currency_code */
407: select gsob.currency_code into
408: l_rt_row.currency_code
409: from hr_organization_information hoi,

Line 504: IF l_rti_row.vendor_site_id IS NOT NULL AND RCV_TABLE_FUNCTIONS.get_pvs_row_from_id(l_rti_row.vendor_site_id).pay_on_code IN ('RECEIPT','RECEIPT_AND_USE') THEN

500: l_rt_row.attribute13 := l_rti_row.attribute13;
501: l_rt_row.attribute14 := l_rti_row.attribute14;
502: l_rt_row.attribute15 := l_rti_row.attribute15;
503: l_rt_row.movement_id := l_rti_row.movement_id;
504: IF l_rti_row.vendor_site_id IS NOT NULL AND RCV_TABLE_FUNCTIONS.get_pvs_row_from_id(l_rti_row.vendor_site_id).pay_on_code IN ('RECEIPT','RECEIPT_AND_USE') THEN
505: l_rt_row.invoice_status_code := 'PENDING';
506: ELSE
507: l_rt_row.invoice_status_code := '';
508: END IF;

Line 557: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_pll_row_from_id(l_rti_row.po_line_location_id).consigned_flag;

553: l_rt_row.secondary_quantity := l_rti_row.secondary_quantity;
554: l_rt_row.secondary_unit_of_measure := l_rti_row.secondary_unit_of_measure;
555: IF l_rti_row.parent_transaction_id IS NULL THEN
556: IF l_rti_row.po_line_location_id IS NOT NULL THEN
557: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_pll_row_from_id(l_rti_row.po_line_location_id).consigned_flag;
558: END IF;
559: ELSE
560: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_rt_row_from_id(l_rti_row.parent_transaction_id).consigned_flag;
561: END IF;

Line 560: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_rt_row_from_id(l_rti_row.parent_transaction_id).consigned_flag;

556: IF l_rti_row.po_line_location_id IS NOT NULL THEN
557: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_pll_row_from_id(l_rti_row.po_line_location_id).consigned_flag;
558: END IF;
559: ELSE
560: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_rt_row_from_id(l_rti_row.parent_transaction_id).consigned_flag;
561: END IF;
562:
563: l_rt_row.lpn_group_id := l_rti_row.lpn_group_id;
564: l_rt_row.amount := l_rti_row.amount;