DBA Data[Home] [Help]

APPS.ASO_CONC_REQ_INT dependencies on HZ_CUST_ACCOUNTS

Line 1035: hz_cust_accounts hca

1031: SELECT qha.quote_number, hca.account_number,
1032: hp.party_type
1033: FROM aso_quote_headers_all qha,
1034: hz_parties hp,
1035: hz_cust_accounts hca
1036: WHERE qha.cust_account_id = hca.cust_account_id(+)
1037: AND hca.party_id = hp.party_id
1038: AND qha.party_id = hca.party_id
1039: AND qha.quote_header_id = p_quote_header_id;

Line 1148: hz_cust_accounts hca

1144: SELECT qha.quote_number, hca.account_number,
1145: hp.party_type,qha.org_id
1146: FROM aso_quote_headers_all qha,
1147: hz_parties hp,
1148: hz_cust_accounts hca
1149: WHERE qha.cust_account_id = hca.cust_account_id(+)
1150: AND qha.cust_party_id = hp.party_id
1151: AND qha.quote_header_id =p_quote_header_id;
1152: