APPS.GMD_OUTBOUND_APIS_PUB dependencies on OE_TRANSACTION_TYPES_ALL

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 1936: cust_vr_table_list := cust_vr_table_list||', oe_transaction_types_all tta';

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:
1936: cust_vr_table_list := cust_vr_table_list||', oe_transaction_types_all tta';
1937: cust_vr_where_clause := cust_vr_where_clause||' AND oeh.order_type_id = tta.transaction_type_id'
1938: ||' AND tta.transaction_type_code = :cust_vr_order_type';
1939: cust_vr_using_clause := cust_vr_using_clause||', gmd_outbound_apis_pub.g_cust_vr_order_type';
1940: END IF;

Line 4173: table_list := table_list ||', oe_transaction_types_all ott ';

4169: END IF;
4170:
4171: IF p_cust_order_type IS NOT NULL
4172: THEN
4173: table_list := table_list ||', oe_transaction_types_all ott ';
4174: where_clause := where_clause ||'AND ooh.order_type_id = ott.transaction_type_id ';
4175:
4176: gmd_outbound_apis_pub.g_cust_order_type := p_cust_order_type;
4177: where_clause := where_clause||'AND ott.transaction_type_code = :cust_order_type ';

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 5232: main_table_list := main_table_list||', oe_transaction_types_all tt';

5228:
5229: IF p_customer_order_type IS NOT NULL
5230: THEN
5231: g_customer_order_type := p_customer_order_type;
5232: main_table_list := main_table_list||', oe_transaction_types_all tt';
5233: main_where_clause := main_where_clause||' AND oh.order_type_id = tt.transaction_type_id'
5234: ||' AND tt.transaction_type_code = :customer_order_type';
5235: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_customer_order_type';
5236: END IF;