APPS.GMD_OUTBOUND_APIS_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 1957: ||' FROM hz_cust_site_uses_all'

1953: THEN
1954: g_cust_vr_ship_to_location := p_cust_vr_ship_to_location;
1955: main_where_clause := main_where_clause||' AND mcvr.ship_to_site_use_id = '
1956: ||' (SELECT site_use_id'
1957: ||' FROM hz_cust_site_uses_all'
1958: ||' WHERE location = :cust_vr_ship_to_location)';
1959: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_ship_to_location';
1960:
1961: cust_vr_where_clause := cust_vr_where_clause||' AND cvr.ship_to_site_use_id = '

Line 1963: ||' FROM hz_cust_site_uses_all'

1959: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_ship_to_location';
1960:
1961: cust_vr_where_clause := cust_vr_where_clause||' AND cvr.ship_to_site_use_id = '
1962: ||' (SELECT site_use_id'
1963: ||' FROM hz_cust_site_uses_all'
1964: ||' WHERE location = :cust_vr_ship_to_location)';
1965: cust_vr_using_clause := cust_vr_using_clause||', gmd_outbound_apis_pub.g_cust_vr_ship_to_location';
1966: END IF;
1967:

Line 4623: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '

4619: END IF;
4620:
4621: IF g_samples_table(i).ship_to_site_id is not NULL
4622: THEN
4623: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '
4624: -- || g_samples_table(i).ship_to_site_id);
4625: SELECT location into g_samples_table(i).ship_to_location
4626: FROM hz_cust_site_uses_all
4627: WHERE site_use_id = g_samples_table(i).ship_to_site_id;

Line 4626: FROM hz_cust_site_uses_all

4622: THEN
4623: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '
4624: -- || g_samples_table(i).ship_to_site_id);
4625: SELECT location into g_samples_table(i).ship_to_location
4626: FROM hz_cust_site_uses_all
4627: WHERE site_use_id = g_samples_table(i).ship_to_site_id;
4628: END IF;
4629:
4630: END LOOP;

Line 5166: ' from hz_cust_site_uses_all '||

5162: g_customer_ship_to_location := p_customer_ship_to_location;
5163: main_where_clause := main_where_clause||
5164: ' AND se.ship_to_site_id IN '||
5165: ' ( select site_use_id '||
5166: ' from hz_cust_site_uses_all '||
5167: ' where location = :customer_ship_to_location)';
5168: main_using_clause := main_using_clause||
5169: ', gmd_outbound_apis_pub.g_customer_ship_to_location';
5170: END IF;

Line 5442: from hz_cust_site_uses_all

5438:
5439: IF g_sample_groups_table(i).ship_to_site_id IS NOT NULL
5440: THEN
5441: select location into g_sample_groups_table(i).ship_to_site_name
5442: from hz_cust_site_uses_all
5443: where site_use_id = g_sample_groups_table(i).ship_to_site_id;
5444: END IF;
5445:
5446: IF g_sample_groups_table(i).supplier_site_id IS NOT NULL