DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 6035: FROM hz_cust_acct_relate_all

6031: AND cust_account_id IN
6032: (SELECT to_number(x_header_rec.customer_id) from dual
6033: UNION
6034: SELECT cust_account_id
6035: FROM hz_cust_acct_relate_all
6036: WHERE related_cust_account_id = x_header_rec.customer_id
6037: AND ship_to_flag = 'Y'
6038: AND status = 'A'
6039: AND org_id = x_header_rec.org_id

Line 6358: FROM HZ_CUST_ACCT_RELATE_ALL

6354: AND SITE_USE.site_use_code = 'BILL_TO'
6355: AND ACCT_SITE.org_id = SITE_USE.org_id
6356: AND ACCT_SITE.CUST_ACCOUNT_ID in
6357: (SELECT DISTINCT cust_account_id
6358: FROM HZ_CUST_ACCT_RELATE_ALL
6359: WHERE related_cust_account_id = x_header_rec.customer_id
6360: AND status='A'
6361: AND bill_to_flag = 'Y'
6362: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', x_header_rec.org_id) IN ('Y', 'A')

Line 6816: FROM hz_cust_acct_relate_all

6812: AND hz.cust_account_id IN
6813: (SELECT to_number(x_header_rec.customer_id) from dual
6814: UNION
6815: SELECT cust_account_id
6816: FROM hz_cust_acct_relate_all
6817: WHERE related_cust_account_id = x_header_rec.customer_id
6818: AND ship_to_flag = 'Y'
6819: AND status = 'A'
6820: AND org_id = x_header_rec.org_id