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 4641: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '

4637:
4638: IF g_samples_table(i).receipt_line_id is not NULL
4639: THEN
4640: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
4641: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '
4642: -- || g_samples_table(i).receipt_line_id);
4643: select rsl.line_num into g_samples_table(i).receipt_line
4644: from rcv_shipment_lines rsl
4645: where rsl.shipment_line_id = g_samples_table(i).receipt_line_id;

Line 4644: from rcv_shipment_lines rsl

4640: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
4641: --dbms_output.put_line('select from rcv_shipment_lines with shipment_line_id of '
4642: -- || g_samples_table(i).receipt_line_id);
4643: select rsl.line_num into g_samples_table(i).receipt_line
4644: from rcv_shipment_lines rsl
4645: where rsl.shipment_line_id = g_samples_table(i).receipt_line_id;
4646: END IF;
4647:
4648: IF g_samples_table(i).ship_to_site_id is not NULL

Line 5473: -- from rcv_shipment_lines rsl, rcv_transactions rt

5469: IF g_sample_groups_table(i).receipt_line_id IS NOT NULL
5470: THEN
5471: -- Bug 3970893: receipt line id is changed from transaction if to shipment line id
5472: -- select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5473: -- from rcv_shipment_lines rsl, rcv_transactions rt
5474: -- where rt.transaction_id = g_sample_groups_table(i).receipt_line_id
5475: select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5476: from rcv_shipment_lines rsl
5477: where rsl.shipment_line_id = g_sample_groups_table(i).receipt_line_id;

Line 5476: from rcv_shipment_lines rsl

5472: -- select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5473: -- from rcv_shipment_lines rsl, rcv_transactions rt
5474: -- where rt.transaction_id = g_sample_groups_table(i).receipt_line_id
5475: select rsl.line_num into g_sample_groups_table(i).receipt_line_number
5476: from rcv_shipment_lines rsl
5477: where rsl.shipment_line_id = g_sample_groups_table(i).receipt_line_id;
5478: END IF;
5479:
5480: IF g_sample_groups_table(i).supplier_id IS NOT NULL