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 191: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching

187: INTO l_rt_row.transaction_id
188: FROM DUAL;
189:
190: -- Bug 4401341
191: /*Commenting the rcv_table_functions.get_rti_frow_from_id call and fetching
192: the value from rti table as lpn_id fetched from the cache table does not
193: have the value that is updated by Inventory.There may be other fields that
194: would have got updated.So fetching all the values directly from rti and then
195: use them to populate rcv_transactions table.

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

193: have the value that is updated by Inventory.There may be other fields that
194: would have got updated.So fetching all the values directly from rti and then
195: use them to populate rcv_transactions table.
196: */
197: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
198:
199: select *
200: into l_rti_row
201: from rcv_transactions_interface

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

220: l_rt_row.user_entered_flag := 'N';
221: l_rt_row.parent_transaction_id := p_receive_id;
222: END IF;
223: ELSIF p_transaction_type IN ('RETURN TO VENDOR','RETURN TO CUSTOMER') THEN
224: l_parent_row := RCV_TABLE_FUNCTIONS.get_rt_row_from_id( l_rti_row.parent_transaction_id );
225: IF l_parent_row.transaction_type = 'DELIVER' THEN
226: l_rt_row.parent_transaction_id := l_parent_row.parent_transaction_id;
227: l_use_ship_to_flag := 'Y';
228: END IF;

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

339: -- Bug 6265149 : End
340:
341: IF l_rti_row.currency_code IS NULL THEN
342:
343: /* Bug 5246147: Removed the function calls rcv_table_functions.get_fspa_row_from_org() and
344: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and
345: added the following sql to get the currency_code */
346: select gsob.currency_code into
347: l_rt_row.currency_code

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

340:
341: IF l_rti_row.currency_code IS NULL THEN
342:
343: /* Bug 5246147: Removed the function calls rcv_table_functions.get_fspa_row_from_org() and
344: rcv_table_functions.get_sob_row_from_id() to get the currency_code value and
345: added the following sql to get the currency_code */
346: select gsob.currency_code into
347: l_rt_row.currency_code
348: from hr_organization_information hoi,

Line 443: 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

439: l_rt_row.attribute13 := l_rti_row.attribute13;
440: l_rt_row.attribute14 := l_rti_row.attribute14;
441: l_rt_row.attribute15 := l_rti_row.attribute15;
442: l_rt_row.movement_id := l_rti_row.movement_id;
443: 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
444: l_rt_row.invoice_status_code := 'PENDING';
445: ELSE
446: l_rt_row.invoice_status_code := '';
447: END IF;

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

484: l_rt_row.secondary_quantity := l_rti_row.secondary_quantity;
485: l_rt_row.secondary_unit_of_measure := l_rti_row.secondary_unit_of_measure;
486: IF l_rti_row.parent_transaction_id IS NULL THEN
487: IF l_rti_row.po_line_location_id IS NOT NULL THEN
488: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_pll_row_from_id(l_rti_row.po_line_location_id).consigned_flag;
489: END IF;
490: ELSE
491: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_rt_row_from_id(l_rti_row.parent_transaction_id).consigned_flag;
492: END IF;

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

487: IF l_rti_row.po_line_location_id IS NOT NULL THEN
488: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_pll_row_from_id(l_rti_row.po_line_location_id).consigned_flag;
489: END IF;
490: ELSE
491: l_rt_row.consigned_flag := RCV_TABLE_FUNCTIONS.get_rt_row_from_id(l_rti_row.parent_transaction_id).consigned_flag;
492: END IF;
493:
494: l_rt_row.lpn_group_id := l_rti_row.lpn_group_id;
495: l_rt_row.amount := l_rti_row.amount;