APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_SITE_USES_ALL

Line 304: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

300: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
301: l_org_id NUMBER;
302: -- l_legal_entity_id NUMBER;
303:
304: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
305: SELECT cust_acct.cust_account_id,
306: cust_Acct.party_id,
307: acct_site.party_site_id,
308: site_use.org_id

Line 310: HZ_CUST_SITE_USES_ALL site_use,

306: cust_Acct.party_id,
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

Line 828: FROM HZ_CUST_SITE_USES_ALL SITE,

824: oe_debug_pub.add('Cr: Yes deliver',2);
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

Line 982: HZ_CUST_SITE_USES_ALL SITE,

978:
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'

Line 1071: , HZ_CUST_SITE_USES_ALL INV

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
1075: AND INV.SITE_USE_ID = p_header_rec.invoice_to_org_id

Line 1122: , HZ_CUST_SITE_USES_ALL SHIP

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
1126: AND SHIP.SITE_USE_ID = p_header_rec.ship_to_org_id

Line 1177: , HZ_CUST_SITE_USES_ALL DELIVER

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
1181: AND DELIVER.SITE_USE_ID = p_header_rec.deliver_to_org_id