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 4650: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '

4646: END IF;
4647:
4648: IF g_samples_table(i).ship_to_site_id is not NULL
4649: THEN
4650: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '
4651: -- || g_samples_table(i).ship_to_site_id);
4652: SELECT location into g_samples_table(i).ship_to_location
4653: FROM hz_cust_site_uses_all
4654: WHERE site_use_id = g_samples_table(i).ship_to_site_id;

Line 4653: FROM hz_cust_site_uses_all

4649: THEN
4650: --dbms_output.put_line('select from hz_cust_site_uses_all with site_use_id of '
4651: -- || g_samples_table(i).ship_to_site_id);
4652: SELECT location into g_samples_table(i).ship_to_location
4653: FROM hz_cust_site_uses_all
4654: WHERE site_use_id = g_samples_table(i).ship_to_site_id;
4655: END IF;
4656:
4657: --7027149 Added sql to get LPN from id

Line 5214: ' from hz_cust_site_uses_all '||

5210: g_customer_ship_to_location := p_customer_ship_to_location;
5211: main_where_clause := main_where_clause||
5212: ' AND se.ship_to_site_id IN '||
5213: ' ( select site_use_id '||
5214: ' from hz_cust_site_uses_all '||
5215: ' where location = :customer_ship_to_location)';
5216: main_using_clause := main_using_clause||
5217: ', gmd_outbound_apis_pub.g_customer_ship_to_location';
5218: END IF;

Line 5490: from hz_cust_site_uses_all

5486:
5487: IF g_sample_groups_table(i).ship_to_site_id IS NOT NULL
5488: THEN
5489: select location into g_sample_groups_table(i).ship_to_site_name
5490: from hz_cust_site_uses_all
5491: where site_use_id = g_sample_groups_table(i).ship_to_site_id;
5492: END IF;
5493:
5494: IF g_sample_groups_table(i).supplier_site_id IS NOT NULL