[Home] [Help]
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: ||' )';
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: ||' )';
4123: END IF;
4124:
4125: IF p_cust_name IS NOT NULL
4126: THEN
4127: table_list := table_list ||', hz_cust_accounts_all hca, hz_parties hp ';
4128: where_clause := where_clause ||'AND gs.cust_id = hca.cust_account_id and hca.party_id = hp.party_id ';
4129:
4130: gmd_outbound_apis_pub.g_cust_name := p_cust_name;
4131: where_clause := where_clause||'AND hp.party_name = :cust_name ';
4522: THEN
4523: --dbms_output.put_line('select from hz_cust_accounts_all with cust_id of '
4524: -- || g_samples_table(i).cust_id);
4525: select hp.party_name into g_samples_table(i).cust_name
4526: from hz_cust_accounts_all hca,hz_parties hp
4527: where hca.cust_account_id = g_samples_table(i).cust_id
4528: and hca.party_id = hp.party_id;
4529: END IF;
4530:
5140:
5141: IF p_customer IS NOT NULL
5142: THEN
5143: g_cust_name := p_customer;
5144: main_table_list := main_table_list ||', hz_cust_accounts_all hca, hz_parties hp ';
5145: main_where_clause := main_where_clause ||' AND se.cust_id = hca.cust_account_id'
5146: ||' AND hca.party_id = hp.party_id'
5147: ||' AND hp.party_name = :cust_name';
5148: main_using_clause := main_using_clause ||', gmd_outbound_apis_pub.g_cust_name ';