APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_SITE_USES_ALL

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

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

Line 309: HZ_CUST_SITE_USES_ALL site_use,

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

Line 797: FROM HZ_CUST_SITE_USES_ALL SITE,

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

Line 951: HZ_CUST_SITE_USES_ALL SITE,

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

Line 1040: , HZ_CUST_SITE_USES_ALL INV

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

Line 1091: , HZ_CUST_SITE_USES_ALL SHIP

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

Line 1146: , HZ_CUST_SITE_USES_ALL DELIVER

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