APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_SITES

Line 310: HZ_CUST_ACCT_SITES_ALL acct_site,

306: acct_site.party_site_id,
307: site_use.org_id
308: FROM
309: HZ_CUST_SITE_USES_ALL site_use,
310: HZ_CUST_ACCT_SITES_ALL acct_site,
311: HZ_CUST_ACCOUNTS_ALL cust_Acct
312: WHERE site_use.site_use_id = p_site_org_id
313: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
314: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 798: HZ_CUST_ACCT_SITES ACCT_SITE

794:
795: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
796: Into l_dummy
797: FROM HZ_CUST_SITE_USES_ALL SITE,
798: HZ_CUST_ACCT_SITES ACCT_SITE
799: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
800: AND SITE.SITE_USE_CODE ='DELIVER_TO'
801: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
802: AND ACCT_SITE.CUST_ACCOUNT_ID in (

Line 952: HZ_CUST_ACCT_SITES ACCT_SITE

948: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
949: INTO l_dummy
950: FROM
951: HZ_CUST_SITE_USES_ALL SITE,
952: HZ_CUST_ACCT_SITES ACCT_SITE
953: WHERE
954: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
955: AND SITE.SITE_USE_CODE = 'SOLD_TO'
956: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1039: , HZ_CUST_ACCT_SITES ACCT_SITE

1035:
1036: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1037: INTO l_dummy
1038: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1039: , HZ_CUST_ACCT_SITES ACCT_SITE
1040: , HZ_CUST_SITE_USES_ALL INV
1041: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
1042: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1043: AND ACCT_SITE.CUST_ACCT_SITE_ID = INV.CUST_ACCT_SITE_ID

Line 1090: , HZ_CUST_ACCT_SITES ACCT_SITE

1086:
1087: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1088: INTO l_dummy
1089: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1090: , HZ_CUST_ACCT_SITES ACCT_SITE
1091: , HZ_CUST_SITE_USES_ALL SHIP
1092: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
1093: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1094: AND ACCT_SITE.CUST_ACCT_SITE_ID = SHIP.CUST_ACCT_SITE_ID

Line 1145: , HZ_CUST_ACCT_SITES ACCT_SITE

1141:
1142: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1143: INTO l_dummy
1144: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1145: , HZ_CUST_ACCT_SITES ACCT_SITE
1146: , HZ_CUST_SITE_USES_ALL DELIVER
1147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
1148: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1149: AND ACCT_SITE.CUST_ACCT_SITE_ID = DELIVER.CUST_ACCT_SITE_ID