APPS.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_ACCT_RELATE

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

Line 9647: FROM HZ_CUST_ACCT_RELATE

9643: rlm_core_sv.dlog(C_DEBUG,'x_site_use_code',x_site_use_code);
9644: --
9645: SELECT 'exists'
9646: INTO v_Temp
9647: FROM HZ_CUST_ACCT_RELATE
9648: WHERE cust_account_id = x_customer_id
9649: AND related_cust_account_id = x_RelatedCustomerId
9650: AND bill_to_flag = 'Y'
9651: AND status='A';

Line 9657: FROM HZ_CUST_ACCT_RELATE

9653: ELSE
9654: --
9655: SELECT 'exists'
9656: INTO v_Temp
9657: FROM HZ_CUST_ACCT_RELATE
9658: WHERE cust_account_id = x_customer_id
9659: AND related_cust_account_id = x_RelatedCustomerId
9660: AND ship_to_flag = 'Y'
9661: AND status='A';