APPS.GMD_OUTBOUND_APIS_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 945: cust_vr_table_list := ' gmd_customer_spec_vrs cvr, fnd_user fu6, fnd_user fu7, oe_order_headers_all oeh';

941: ||', cvr.attribute26, cvr.attribute27, cvr.attribute28, cvr.attribute29, cvr.attribute30'
942: ||', cvr.creation_date, cvr.created_by, fu6.user_name, cvr.last_update_date'
943: ||', cvr.last_updated_by, fu7.user_name, cvr.last_update_login'
944: ||')';
945: cust_vr_table_list := ' gmd_customer_spec_vrs cvr, fnd_user fu6, fnd_user fu7, oe_order_headers_all oeh';
946:
947: cust_vr_where_clause := ' cvr.created_by = fu6.user_id AND cvr.last_updated_by = fu7.user_id'
948: ||' AND cvr.spec_id = gs.spec_id AND cvr.order_id = oeh.header_id(+) AND 1=:dummy3';
949:

Line 1868: ||' from oe_order_headers_all'

1864: IF p_cust_vr_order_number IS NOT NULL
1865: THEN
1866: g_cust_vr_order_number := p_cust_vr_order_number;
1867: main_where_clause := main_where_clause||' AND mcvr.order_id = (select header_id '
1868: ||' from oe_order_headers_all'
1869: ||' where order_number = :cust_vr_order_number)';
1870: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_order_number';
1871:
1872: cust_vr_where_clause := cust_vr_where_clause||' AND oeh.order_number = :cust_vr_order_number';

Line 1931: ||' FROM oe_order_headers_all h, oe_transaction_types_all t'

1927: IF p_cust_vr_order_type IS NOT NULL
1928: THEN
1929: g_cust_vr_order_type := p_cust_vr_order_type;
1930: main_where_clause := main_where_clause||' AND mcvr.order_id IN (select header_id '
1931: ||' FROM oe_order_headers_all h, oe_transaction_types_all t'
1932: ||' WHERE h.order_type_id = t.transaction_type_id'
1933: ||' AND t.transaction_type_code = :cust_vr_order_type)';
1934: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_order_type';
1935:

Line 4161: table_list := table_list ||', oe_order_headers_all ooh ';

4157: -- dbms_output.put_line('after shipto site id');
4158:
4159: IF p_cust_order is NOT NULL or p_cust_order_type is NOT NULL
4160: THEN
4161: table_list := table_list ||', oe_order_headers_all ooh ';
4162: where_clause := where_clause ||'AND gs.order_id = ooh.header_id ';
4163:
4164: IF p_cust_order IS NOT NULL
4165: THEN

Line 4560: --dbms_output.put_line('select from oe_order_headers_all with header_id of '

4556: END IF;
4557:
4558: IF g_samples_table(i).order_id is not NULL
4559: THEN
4560: --dbms_output.put_line('select from oe_order_headers_all with header_id of '
4561: -- || g_samples_table(i).order_id);
4562: select ooh.order_number, ott.transaction_type_code into
4563: g_samples_table(i).order_number, g_samples_table(i).order_type
4564: from oe_order_headers_all ooh, oe_transaction_types_all ott

Line 4564: from oe_order_headers_all ooh, oe_transaction_types_all ott

4560: --dbms_output.put_line('select from oe_order_headers_all with header_id of '
4561: -- || g_samples_table(i).order_id);
4562: select ooh.order_number, ott.transaction_type_code into
4563: g_samples_table(i).order_number, g_samples_table(i).order_type
4564: from oe_order_headers_all ooh, oe_transaction_types_all ott
4565: where ooh.header_id = g_samples_table(i).order_id and
4566: ooh.order_type_id = ott.transaction_type_id ;
4567: END IF;
4568:

Line 4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'

4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
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(+)'