APPS.OE_BULK_PROCESS_HEADER dependencies on HZ_CUST_ACCT_SITES

Line 229: HZ_CUST_ACCT_SITES_ALL acct_site,

225: acct_site.party_site_id,
226: site_use.org_id
227: FROM
228: HZ_CUST_SITE_USES_ALL site_use,
229: HZ_CUST_ACCT_SITES_ALL acct_site,
230: HZ_CUST_ACCOUNTS_ALL cust_Acct
231: WHERE site_use.site_use_id = p_site_org_id
232: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
233: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 400: hz_cust_acct_sites acct_site

396: INTO
397: l_dummy
398: FROM
399: hz_cust_site_uses site_use,
400: hz_cust_acct_sites acct_site
401: WHERE
402: site_use.site_use_id=p_end_customer_site_use_id
403: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
404: and acct_site.cust_account_id=p_end_customer_id;

Line 1620: HZ_CUST_ACCT_SITES ADDR

1616: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1617: INTO l_dummy
1618: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1619: HZ_CUST_SITE_USES_ALL SITE,
1620: HZ_CUST_ACCT_SITES ADDR
1621: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1622: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
1623: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1624: AND ADDR.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID