APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_SITES

Line 951: HZ_CUST_ACCT_SITES_ALL acct_site,

947: acct_site.party_site_id,
948: site_use.org_id
949: FROM
950: HZ_CUST_SITE_USES_ALL site_use,
951: HZ_CUST_ACCT_SITES_ALL acct_site,
952: HZ_CUST_ACCOUNTS_ALL cust_Acct
953: WHERE site_use.site_use_id = p_site_org_id
954: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
955: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 1613: HZ_CUST_ACCT_SITES ACCT_SITE

1609: l_site_use_code := 'SHIP_TO' ;
1610: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1611: Into l_dummy
1612: FROM HZ_CUST_SITE_USES_ALL SITE,
1613: HZ_CUST_ACCT_SITES ACCT_SITE
1614: WHERE SITE.SITE_USE_ID = p_header_rec.ship_to_org_id
1615: AND SITE.SITE_USE_CODE = l_site_use_code
1616: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1617: AND SITE.STATUS = 'A'

Line 1709: HZ_CUST_ACCT_SITES ACCT_SITE

1705: l_site_use_code := 'DELIVER_TO' ;
1706: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1707: Into l_dummy
1708: FROM HZ_CUST_SITE_USES_ALL SITE,
1709: HZ_CUST_ACCT_SITES ACCT_SITE
1710: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
1711: AND SITE.SITE_USE_CODE = l_site_use_code
1712: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1713: AND SITE.STATUS = 'A'

Line 1806: HZ_CUST_ACCT_SITES ACCT_SITE

1802: l_site_use_code := 'BILL_TO' ;
1803: SELECT 'VALID'
1804: Into l_dummy
1805: FROM HZ_CUST_SITE_USES_ALL SITE,
1806: HZ_CUST_ACCT_SITES ACCT_SITE
1807: WHERE SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
1808: AND SITE.SITE_USE_CODE = l_site_use_code
1809: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1810: AND SITE.STATUS = 'A'

Line 1868: HZ_CUST_ACCT_SITES ACCT_SITE

1864: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1865: INTO l_dummy
1866: FROM
1867: HZ_CUST_SITE_USES_ALL SITE,
1868: HZ_CUST_ACCT_SITES ACCT_SITE
1869: WHERE
1870: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
1871: AND SITE.SITE_USE_CODE = 'SOLD_TO'
1872: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1974: hz_cust_acct_sites acct_site

1970: INTO
1971: l_dummy
1972: FROM
1973: hz_cust_site_uses_all site_use,
1974: hz_cust_acct_sites acct_site
1975: WHERE
1976: site_use.site_use_id=p_header_rec.end_customer_site_use_id
1977: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
1978: and acct_site.cust_account_id=p_header_rec.end_customer_id;

Line 2075: HZ_CUST_ACCT_SITES ADDR

2071: INTO l_dummy
2072: FROM
2073: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2074: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2075: HZ_CUST_ACCT_SITES ADDR
2076: WHERE
2077: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
2078: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2079: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2134: HZ_CUST_ACCT_SITES ADDR

2130: INTO l_dummy
2131: FROM
2132: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2133: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2134: HZ_CUST_ACCT_SITES ADDR
2135: WHERE
2136: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
2137: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2138: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2194: HZ_CUST_ACCT_SITES ADDR

2190: INTO l_dummy
2191: FROM
2192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2193: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2194: HZ_CUST_ACCT_SITES ADDR
2195: WHERE
2196: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
2197: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
2198: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'