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 4171: table_list := table_list ||', oe_transaction_types_all ott ';

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

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

5180:
5181: IF p_customer_order_type IS NOT NULL
5182: THEN
5183: g_customer_order_type := p_customer_order_type;
5184: main_table_list := main_table_list||', oe_transaction_types_all tt';
5185: main_where_clause := main_where_clause||' AND oh.order_type_id = tt.transaction_type_id'
5186: ||' AND tt.transaction_type_code = :customer_order_type';
5187: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_customer_order_type';
5188: END IF;