APPS.GMD_OUTBOUND_APIS_PUB dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1837: ||' FROM hz_parties hzp, hz_cust_accounts_all hzca'

1833: THEN
1834: g_cust_vr_customer := p_cust_vr_customer;
1835: main_where_clause := main_where_clause||' AND mcvr.cust_id IN'
1836: ||' (SELECT hzca.cust_account_id'
1837: ||' FROM hz_parties hzp, hz_cust_accounts_all hzca'
1838: ||' WHERE hzp.party_id = hzca.party_id AND'
1839: ||' UPPER(hzp.party_name)'
1840: ||' LIKE UPPER(:cust_vr_customer)'
1841: ||' )';

Line 1846: ||' FROM hz_parties hzp, hz_cust_accounts_all hzca'

1842: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_customer';
1843:
1844: cust_vr_where_clause := cust_vr_where_clause||' AND cvr.cust_id IN'
1845: ||' (SELECT hzca.cust_account_id'
1846: ||' FROM hz_parties hzp, hz_cust_accounts_all hzca'
1847: ||' WHERE hzp.party_id = hzca.party_id AND'
1848: ||' UPPER(hzp.party_name)'
1849: ||' LIKE UPPER(:cust_vr_customer)'
1850: ||' )';

Line 4129: table_list := table_list ||', hz_cust_accounts_all hca, hz_parties hp ';

4125: END IF;
4126:
4127: IF p_cust_name IS NOT NULL
4128: THEN
4129: table_list := table_list ||', hz_cust_accounts_all hca, hz_parties hp ';
4130: where_clause := where_clause ||'AND gs.cust_id = hca.cust_account_id and hca.party_id = hp.party_id ';
4131:
4132: gmd_outbound_apis_pub.g_cust_name := p_cust_name;
4133: where_clause := where_clause||'AND hp.party_name = :cust_name ';

Line 4550: --dbms_output.put_line('select from hz_cust_accounts_all with cust_id of '

4546: END IF;
4547:
4548: IF g_samples_table(i).cust_id is not NULL
4549: THEN
4550: --dbms_output.put_line('select from hz_cust_accounts_all with cust_id of '
4551: -- || g_samples_table(i).cust_id);
4552: select hp.party_name into g_samples_table(i).cust_name
4553: from hz_cust_accounts_all hca,hz_parties hp
4554: where hca.cust_account_id = g_samples_table(i).cust_id

Line 4553: from hz_cust_accounts_all hca,hz_parties hp

4549: THEN
4550: --dbms_output.put_line('select from hz_cust_accounts_all with cust_id of '
4551: -- || g_samples_table(i).cust_id);
4552: select hp.party_name into g_samples_table(i).cust_name
4553: from hz_cust_accounts_all hca,hz_parties hp
4554: where hca.cust_account_id = g_samples_table(i).cust_id
4555: and hca.party_id = hp.party_id;
4556: END IF;
4557:

Line 5192: main_table_list := main_table_list ||', hz_cust_accounts_all hca, hz_parties hp ';

5188:
5189: IF p_customer IS NOT NULL
5190: THEN
5191: g_cust_name := p_customer;
5192: main_table_list := main_table_list ||', hz_cust_accounts_all hca, hz_parties hp ';
5193: main_where_clause := main_where_clause ||' AND se.cust_id = hca.cust_account_id'
5194: ||' AND hca.party_id = hp.party_id'
5195: ||' AND hp.party_name = :cust_name';
5196: main_using_clause := main_using_clause ||', gmd_outbound_apis_pub.g_cust_name ';