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.GMD_OUTBOUND_APIS_PUB dependencies on RCV_SHIPMENT_LINES

Line 4614: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '

4610:
4611: IF g_samples_table(i).receipt_line_id is not NULL
4612: THEN
4613: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
4614: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '
4615: -- || g_samples_table(i).receipt_line_id);
4616: select rsl.line_num into g_samples_table(i).receipt_line
4617: from rcv_shipment_lines rsl
4618: where rsl.shipment_line_id = g_samples_table(i).receipt_line_id;

Line 4617: from rcv_shipment_lines rsl

4613: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
4614: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '
4615: -- || g_samples_table(i).receipt_line_id);
4616: select rsl.line_num into g_samples_table(i).receipt_line
4617: from rcv_shipment_lines rsl
4618: where rsl.shipment_line_id = g_samples_table(i).receipt_line_id;
4619: END IF;
4620:
4621: IF g_samples_table(i).ship_to_site_id is not NULL

Line 5425: -- from rcv_shipment_lines rsl, rcv_transactions rt

5421: IF g_sample_groups_table(i).receipt_line_id IS NOT NULL
5422: THEN
5423: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
5424: -- select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5425: -- from rcv_shipment_lines rsl, rcv_transactions rt
5426: -- where rt.transaction_id = g_sample_groups_table(i).receipt_line_id
5427: select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5428: from rcv_shipment_lines rsl
5429: where rsl.shipment_line_id = g_sample_groups_table(i).receipt_line_id;

Line 5428: from rcv_shipment_lines rsl

5424: -- select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5425: -- from rcv_shipment_lines rsl, rcv_transactions rt
5426: -- where rt.transaction_id = g_sample_groups_table(i).receipt_line_id
5427: select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5428: from rcv_shipment_lines rsl
5429: where rsl.shipment_line_id = g_sample_groups_table(i).receipt_line_id;
5430: END IF;
5431:
5432: IF g_sample_groups_table(i).supplier_id IS NOT NULL