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.

[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on PO_LINES_ALL

Line 2104: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'

2100: IF p_supl_vr_po_number IS NOT NULL
2101: THEN
2102: g_supl_vr_po_number := p_supl_vr_po_number;
2103: main_where_clause := main_where_clause||' AND msvr.po_line_id IN'
2104: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'
2105: ||' WHERE pha.segment1 = :supl_vr_po_number'
2106: ||' AND pha.po_header_id = pla.po_header_id)';
2107: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2108:

Line 2110: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'

2106: ||' AND pha.po_header_id = pla.po_header_id)';
2107: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2108:
2109: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'
2110: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'
2111: ||' WHERE pha.segment1 = :supl_vr_po_number'
2112: ||' AND pha.po_header_id = pla.po_header_id)';
2113: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2114: END IF;

Line 2120: ||' (SELECT po_line_id FROM po_lines_all'

2116: IF p_supl_vr_po_id IS NOT NULL
2117: THEN
2118: g_supl_vr_po_id := p_supl_vr_po_id;
2119: main_where_clause := main_where_clause||' AND msvr.po_line_id IN'
2120: ||' (SELECT po_line_id FROM po_lines_all'
2121: ||' WHERE po_header_id = :supl_vr_po_id)';
2122: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_id';
2123:
2124: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'

Line 2125: ||' (SELECT po_line_id FROM po_lines_all'

2121: ||' WHERE po_header_id = :supl_vr_po_id)';
2122: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_id';
2123:
2124: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'
2125: ||' (SELECT po_line_id FROM po_lines_all'
2126: ||' WHERE po_header_id = :supl_vr_po_id)';
2127: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_id';
2128: END IF;
2129:

Line 2134: ||' (SELECT po_line_id FROM po_lines_all'

2130: IF p_supl_vr_po_line_no IS NOT NULL
2131: THEN
2132: g_supl_vr_po_line_no := p_supl_vr_po_line_no;
2133: main_where_clause := main_where_clause||' AND msvr.po_line_id IN'
2134: ||' (SELECT po_line_id FROM po_lines_all'
2135: ||' WHERE line_num = :supl_vr_po_line_no)';
2136: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_line_no';
2137:
2138: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'

Line 2139: ||' (SELECT po_line_id FROM po_lines_all'

2135: ||' WHERE line_num = :supl_vr_po_line_no)';
2136: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_line_no';
2137:
2138: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'
2139: ||' (SELECT po_line_id FROM po_lines_all'
2140: ||' WHERE line_num = :supl_vr_po_line_no)';
2141: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_line_no';
2142: END IF;
2143:

Line 4249: table_list := table_list ||', po_lines_all pl ';

4245: END IF;
4246:
4247: IF p_supplier_po_line IS NOT NULL
4248: THEN
4249: table_list := table_list ||', po_lines_all pl ';
4250: where_clause := where_clause ||'AND gs.po_line_id = pl.po_line_id ';
4251:
4252: gmd_outbound_apis_pub.g_supplier_po_line := p_supplier_po_line;
4253: where_clause := where_clause||'AND pl.line_num = :supplier_po_line ';

Line 4622: --dbms_output.put_line('select from po_lines_all with po_line_id of '

4618: END IF;
4619:
4620: IF g_samples_table(i).po_line_id is not NULL
4621: THEN
4622: --dbms_output.put_line('select from po_lines_all with po_line_id of '
4623: -- || g_samples_table(i).po_line_id);
4624: select line_num into g_samples_table(i).po_line_number
4625: from po_lines_all
4626: where po_line_id = g_samples_table(i).po_line_id;

Line 4625: from po_lines_all

4621: THEN
4622: --dbms_output.put_line('select from po_lines_all with po_line_id of '
4623: -- || g_samples_table(i).po_line_id);
4624: select line_num into g_samples_table(i).po_line_number
4625: from po_lines_all
4626: where po_line_id = g_samples_table(i).po_line_id;
4627: END IF;
4628:
4629: IF g_samples_table(i).receipt_id is not NULL

Line 4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'

4879:
4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4884: ||',mtl_parameters mp';
4885:
4886: main_where_clause:=' 1=:dummy AND se.receipt_id = rh.shipment_header_id(+)'
4887: ||' AND se.po_header_id = ph.po_header_id(+)'