APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2650: hz_cust_acct_sites_all cas

2646: and h.org_id =ratrx.org_id
2647: union
2648: select cas.cust_account_id customer_id
2649: from hz_cust_site_uses_all su,
2650: hz_cust_acct_sites_all cas
2651: where cas.cust_acct_site_id = su.cust_acct_site_id
2652: and su.site_use_id = p_line_rec.invoice_to_org_id
2653: and cas.org_id=ratrx.org_id
2654: union

Line 2658: hz_cust_acct_sites_all cas

2654: union
2655: select c.cust_account_id customer_id
2656: from hz_cust_acct_relate_all c,
2657: hz_cust_site_uses_all su,
2658: hz_cust_acct_sites_all cas
2659: where cas.cust_acct_site_id = su.cust_acct_site_id
2660: and su.site_use_id = p_line_rec.invoice_to_org_id
2661: and c.related_cust_account_id = cas.cust_account_id
2662: and c.status = 'A'

Line 3927: HZ_CUST_ACCT_SITES_ALL acct_site,

3923: acct_site.party_site_id,
3924: site_use.org_id
3925: FROM
3926: HZ_CUST_SITE_USES_ALL site_use,
3927: HZ_CUST_ACCT_SITES_ALL acct_site,
3928: HZ_CUST_ACCOUNTS_ALL cust_Acct
3929: WHERE site_use.site_use_id = p_site_org_id
3930: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
3931: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 5927: HZ_CUST_ACCT_SITES_ALL ADDR

5923: INTO l_dummy
5924: FROM
5925: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5926: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5927: HZ_CUST_ACCT_SITES_ALL ADDR
5928: WHERE
5929: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
5930: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
5931: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'