APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_SITES

Line 311: HZ_CUST_ACCT_SITES_ALL acct_site,

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

Line 829: HZ_CUST_ACCT_SITES ACCT_SITE

825:
826: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
827: Into l_dummy
828: FROM HZ_CUST_SITE_USES_ALL SITE,
829: HZ_CUST_ACCT_SITES ACCT_SITE
830: WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
831: AND SITE.SITE_USE_CODE ='DELIVER_TO'
832: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
833: AND ACCT_SITE.CUST_ACCOUNT_ID in (

Line 983: HZ_CUST_ACCT_SITES ACCT_SITE

979: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
980: INTO l_dummy
981: FROM
982: HZ_CUST_SITE_USES_ALL SITE,
983: HZ_CUST_ACCT_SITES ACCT_SITE
984: WHERE
985: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
986: AND SITE.SITE_USE_CODE = 'SOLD_TO'
987: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1070: , HZ_CUST_ACCT_SITES ACCT_SITE

1066:
1067: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1068: INTO l_dummy
1069: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1070: , HZ_CUST_ACCT_SITES ACCT_SITE
1071: , HZ_CUST_SITE_USES_ALL INV
1072: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
1073: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1074: AND ACCT_SITE.CUST_ACCT_SITE_ID = INV.CUST_ACCT_SITE_ID

Line 1121: , HZ_CUST_ACCT_SITES ACCT_SITE

1117:
1118: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1119: INTO l_dummy
1120: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1121: , HZ_CUST_ACCT_SITES ACCT_SITE
1122: , HZ_CUST_SITE_USES_ALL SHIP
1123: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
1124: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1125: AND ACCT_SITE.CUST_ACCT_SITE_ID = SHIP.CUST_ACCT_SITE_ID

Line 1176: , HZ_CUST_ACCT_SITES ACCT_SITE

1172:
1173: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1174: INTO l_dummy
1175: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1176: , HZ_CUST_ACCT_SITES ACCT_SITE
1177: , HZ_CUST_SITE_USES_ALL DELIVER
1178: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
1179: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1180: AND ACCT_SITE.CUST_ACCT_SITE_ID = DELIVER.CUST_ACCT_SITE_ID