APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_SITES

Line 982: HZ_CUST_ACCT_SITES_ALL acct_site,

978: acct_site.party_site_id,
979: site_use.org_id
980: FROM
981: HZ_CUST_SITE_USES_ALL site_use,
982: HZ_CUST_ACCT_SITES_ALL acct_site,
983: HZ_CUST_ACCOUNTS_ALL cust_Acct
984: WHERE site_use.site_use_id = p_site_org_id
985: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
986: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 1681: HZ_CUST_ACCT_SITES ACCT_SITE

1677: l_site_use_code := 'SHIP_TO' ;
1678: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1679: Into l_dummy
1680: FROM HZ_CUST_SITE_USES_ALL SITE,
1681: HZ_CUST_ACCT_SITES ACCT_SITE
1682: WHERE SITE.SITE_USE_ID = p_header_rec.ship_to_org_id
1683: AND SITE.SITE_USE_CODE = l_site_use_code
1684: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1685: AND SITE.STATUS = 'A'

Line 1777: HZ_CUST_ACCT_SITES ACCT_SITE

1773: l_site_use_code := 'DELIVER_TO' ;
1774: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1775: Into l_dummy
1776: FROM HZ_CUST_SITE_USES_ALL SITE,
1777: HZ_CUST_ACCT_SITES ACCT_SITE
1778: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
1779: AND SITE.SITE_USE_CODE = l_site_use_code
1780: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1781: AND SITE.STATUS = 'A'

Line 1874: HZ_CUST_ACCT_SITES ACCT_SITE

1870: l_site_use_code := 'BILL_TO' ;
1871: SELECT 'VALID'
1872: Into l_dummy
1873: FROM HZ_CUST_SITE_USES_ALL SITE,
1874: HZ_CUST_ACCT_SITES ACCT_SITE
1875: WHERE SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
1876: AND SITE.SITE_USE_CODE = l_site_use_code
1877: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1878: AND SITE.STATUS = 'A'

Line 1937: HZ_CUST_ACCT_SITES ACCT_SITE

1933: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1934: INTO l_dummy
1935: FROM
1936: HZ_CUST_SITE_USES_ALL SITE,
1937: HZ_CUST_ACCT_SITES ACCT_SITE
1938: WHERE
1939: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
1940: AND SITE.SITE_USE_CODE = 'SOLD_TO'
1941: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 2043: hz_cust_acct_sites acct_site

2039: INTO
2040: l_dummy
2041: FROM
2042: hz_cust_site_uses_all site_use,
2043: hz_cust_acct_sites acct_site
2044: WHERE
2045: site_use.site_use_id=p_header_rec.end_customer_site_use_id
2046: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
2047: and acct_site.cust_account_id=p_header_rec.end_customer_id;

Line 2144: HZ_CUST_ACCT_SITES ADDR

2140: INTO l_dummy
2141: FROM
2142: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2143: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2144: HZ_CUST_ACCT_SITES ADDR
2145: WHERE
2146: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
2147: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2148: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2203: HZ_CUST_ACCT_SITES ADDR

2199: INTO l_dummy
2200: FROM
2201: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2202: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2203: HZ_CUST_ACCT_SITES ADDR
2204: WHERE
2205: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
2206: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2207: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2263: HZ_CUST_ACCT_SITES ADDR

2259: INTO l_dummy
2260: FROM
2261: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2262: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2263: HZ_CUST_ACCT_SITES ADDR
2264: WHERE
2265: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
2266: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2267: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'