APPS.XNB_SALES_ORDER_PVT dependencies on HZ_CUST_ACCOUNTS

Line 182: FROM hz_cust_accounts

178: BEGIN
179:
180: SELECT account_number
181: INTO l_acct_num
182: FROM hz_cust_accounts
183: WHERE cust_account_id = l_cust_acct_id;
184:
185: EXCEPTION
186:

Line 749: hz_cust_accounts b,

745: l_postal_code
746: FROM
747: hz_cust_site_uses_all p,
748: hz_cust_acct_sites_all a,
749: hz_cust_accounts b,
750: hz_parties c,
751: hz_party_sites d,
752: hz_locations locations
753: WHERE

Line 879: ' FROM HZ_PARTIES A, HZ_CUST_ACCOUNTS B '||

875: 'B.ATTRIBUTE14, '||
876: 'B.ATTRIBUTE15, '''||l_doc_id||''','''||l_party_number||''','''||l_party_name||''','''||l_account_number||''','''||
877: l_account_name||''','''||l_primary_bill_to_flag||''','''||l_bill_to_owner_flag||''','''||l_bill_to_address||''','''||
878: l_country||''','''||l_state||''','''||l_county||''','''||l_city||''','''||l_postal_code||''''||
879: ' FROM HZ_PARTIES A, HZ_CUST_ACCOUNTS B '||
880: ' WHERE A.PARTY_ID = B.PARTY_ID AND A.PARTY_ID = '||l_party_id||' AND B.CUST_ACCOUNT_ID = '||l_account_id||')';
881:
882: -------------------------------------------------------------------------------------------
883: --Execute the Query

Line 1125: hz_cust_accounts b,

1121: p_postal_code
1122: FROM
1123: hz_cust_site_uses_all p,
1124: hz_cust_acct_sites_all a,
1125: hz_cust_accounts b,
1126: hz_parties c,
1127: hz_party_sites d,
1128: hz_locations locations
1129: WHERE