APPS.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_ACCT_RELATE

Line 6074: FROM hz_cust_acct_relate_all

6070: AND cust_account_id IN
6071: (SELECT to_number(x_header_rec.customer_id) from dual
6072: UNION
6073: SELECT cust_account_id
6074: FROM hz_cust_acct_relate_all
6075: WHERE related_cust_account_id = x_header_rec.customer_id
6076: AND ship_to_flag = 'Y'
6077: AND status = 'A'
6078: AND org_id = x_header_rec.org_id

Line 6438: FROM HZ_CUST_ACCT_RELATE_ALL

6434: AND SITE_USE.site_use_code = 'BILL_TO'
6435: AND ACCT_SITE.org_id = SITE_USE.org_id
6436: AND ACCT_SITE.CUST_ACCOUNT_ID in
6437: (SELECT DISTINCT cust_account_id
6438: FROM HZ_CUST_ACCT_RELATE_ALL
6439: WHERE related_cust_account_id = x_header_rec.customer_id
6440: AND status='A'
6441: AND bill_to_flag = 'Y'
6442: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', x_header_rec.org_id) IN ('Y', 'A')

Line 6829: FROM hz_cust_acct_relate_all

6825: AND hz.cust_account_id IN
6826: (SELECT to_number(x_header_rec.customer_id) from dual
6827: UNION
6828: SELECT cust_account_id
6829: FROM hz_cust_acct_relate_all
6830: WHERE related_cust_account_id = x_header_rec.customer_id
6831: AND ship_to_flag = 'Y'
6832: AND status = 'A'
6833: AND org_id = x_header_rec.org_id

Line 9571: FROM HZ_CUST_ACCT_RELATE

9567: rlm_core_sv.dlog(C_DEBUG,'x_site_use_code',x_site_use_code);
9568: --
9569: SELECT 'exists'
9570: INTO v_Temp
9571: FROM HZ_CUST_ACCT_RELATE
9572: WHERE cust_account_id = x_customer_id
9573: AND related_cust_account_id = x_RelatedCustomerId
9574: AND bill_to_flag = 'Y'
9575: AND status='A';

Line 9581: FROM HZ_CUST_ACCT_RELATE

9577: ELSE
9578: --
9579: SELECT 'exists'
9580: INTO v_Temp
9581: FROM HZ_CUST_ACCT_RELATE
9582: WHERE cust_account_id = x_customer_id
9583: AND related_cust_account_id = x_RelatedCustomerId
9584: AND ship_to_flag = 'Y'
9585: AND status='A';