APPS.OE_DEFAULT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 154: HZ_CUST_ACCT_SITES ACCT_SITE

150: Select party_site.party_id, acct_site.cust_account_id
151: Into l_party_id, l_cust_account_id
152: From HZ_CUST_SITE_USES_ALL SITE,
153: HZ_PARTY_SITES PARTY_SITE,
154: HZ_CUST_ACCT_SITES ACCT_SITE
155: Where SITE.SITE_USE_ID = l_invoice_to_org_id
156: AND SITE.SITE_USE_CODE = 'BILL_TO'
157: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
158: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 787: HZ_CUST_ACCT_SITES_ALL acct_site,

783: acct_site.party_site_id,
784: site_use.org_id
785: FROM
786: HZ_CUST_SITE_USES_ALL site_use,
787: HZ_CUST_ACCT_SITES_ALL acct_site,
788: HZ_CUST_ACCOUNTS_ALL cust_Acct
789: WHERE site_use.site_use_id = p_site_org_id
790: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
791: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 1576: FROM HZ_CUST_ACCT_SITES ADDR

1572: BEGIN
1573:
1574: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
1575: INTO l_site_use_id
1576: FROM HZ_CUST_ACCT_SITES ADDR
1577: ,HZ_CUST_SITE_USES_ALL SITE
1578: WHERE ADDR.CUST_ACCOUNT_ID = l_sold_to_org_id
1579: AND ADDR.STATUS = 'A'
1580: AND SITE.CUST_ACCT_SITE_ID = ADDR.CUST_ACCT_SITE_ID

Line 1746: FROM HZ_CUST_ACCT_SITES ADDR

1742: BEGIN
1743:
1744: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
1745: INTO l_site_use_id
1746: FROM HZ_CUST_ACCT_SITES ADDR
1747: ,HZ_CUST_SITE_USES_ALL SITE
1748: WHERE ADDR.CUST_ACCOUNT_ID = l_sold_to_org_id
1749: AND ADDR.STATUS = 'A'
1750: AND SITE.CUST_ACCT_SITE_ID = ADDR.CUST_ACCT_SITE_ID