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 4159: table_list := table_list ||', oe_order_headers_all ooh ';

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

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

4529: END IF;
4530:
4531: IF g_samples_table(i).order_id is not NULL
4532: THEN
4533: --dbms_output.put_line('select from oe_order_headers_all with header_id of '
4534: -- || g_samples_table(i).order_id);
4535: select ooh.order_number, ott.transaction_type_code into
4536: g_samples_table(i).order_number, g_samples_table(i).order_type
4537: from oe_order_headers_all ooh, oe_transaction_types_all ott

Line 4537: from oe_order_headers_all ooh, oe_transaction_types_all ott

4533: --dbms_output.put_line('select from oe_order_headers_all with header_id of '
4534: -- || g_samples_table(i).order_id);
4535: select ooh.order_number, ott.transaction_type_code into
4536: g_samples_table(i).order_number, g_samples_table(i).order_type
4537: from oe_order_headers_all ooh, oe_transaction_types_all ott
4538: where ooh.header_id = g_samples_table(i).order_id and
4539: ooh.order_type_id = ott.transaction_type_id ;
4540: END IF;
4541:

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

4830: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4831:
4832: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4836: ||',mtl_parameters mp';
4837:
4838: main_where_clause:=' 1=:dummy AND se.receipt_id = rh.shipment_header_id(+)'