[Home] [Help]
98: IS
99: SELECT hp.party_name,
100: hca.account_number
101: FROM hz_parties hp,
102: hz_cust_accounts hca
103: WHERE hca.party_id = hp.party_id
104: AND hca.cust_account_id = p_customer_id;
105:
106: l_org_id NUMBER;
130: p_org_id IN NUMBER) is
131: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
132: FROM HZ_CUST_SITE_USES_ALL HCSU,
133: HZ_CUST_ACCT_SITES_ALL HCAS,
134: HZ_CUST_ACCOUNTS HCA,
135: HZ_PARTY_SITES HPS
136: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
137: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
138: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
153: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
154: FROM HZ_CUST_SITE_USES_ALL HCSU,
155: HZ_CUST_ACCT_SITES_ALL HCAS,
156: HZ_PARTY_SITES HPS,
157: HZ_CUST_ACCOUNTS HCA,
158: HZ_CUST_ACCT_RELATE_ALL HCAR
159: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
160: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
161: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
840: FROM
841: HZ_CUST_SITE_USES_ALL HCSU,
842: HZ_CUST_ACCT_SITES_ALL HCAS,
843: HZ_PARTY_SITES HPS,
844: HZ_CUST_ACCOUNTS HCA,
845: HZ_PARTIES HP,
846: WSH_LOCATIONS WL1
847: WHERE
848: WL1.wsh_location_id = p_loc_id AND
900: SELECT HCSU.LOCATION
901: FROM HZ_CUST_SITE_USES_ALL HCSU,
902: HZ_CUST_ACCT_SITES_ALL HCAS,
903: HZ_PARTY_SITES HPS,
904: HZ_CUST_ACCOUNTS HCA,
905: HZ_CUST_ACCT_RELATE_ALL HCAR
906: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
907: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
908: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
920:
921: CURSOR c_cust_info_cur(p_customer_id IN NUMBER) IS
922: SELECT HP.PARTY_NAME, HP.PARTY_NUMBER
923: FROM HZ_PARTIES HP,
924: HZ_CUST_ACCOUNTS HCA
925: WHERE HP.PARTY_ID = HCA.PARTY_ID
926: AND HCA.CUST_ACCOUNT_ID = p_customer_id;
927:
928: l_deliver_to_site_use_id NUMBER;
1396: c_org_id IN NUMBER) IS
1397: SELECT hcsu.location
1398: FROM hz_cust_site_uses_all hcsu,
1399: hz_cust_acct_sites_all hcas,
1400: hz_cust_accounts hca,
1401: hz_party_sites hps
1402: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1403: AND hcas.party_site_id = hps.party_site_id
1404: AND hcas.cust_account_id = hca.cust_account_id
1418: SELECT hcsu.location
1419: FROM hz_cust_site_uses_all hcsu,
1420: hz_cust_acct_sites_all hcas,
1421: hz_party_sites hps,
1422: hz_cust_accounts hca,
1423: hz_cust_acct_relate_all hcar
1424: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1425: AND hcas.party_site_id = hps.party_site_id
1426: AND hcas.cust_account_id = hca.cust_account_id
1438: -- Distributed - TPW Changes
1439: CURSOR c_cust_name_cur( c_customer_id IN NUMBER ) IS
1440: SELECT hp.party_name
1441: FROM hz_parties hp,
1442: hz_cust_accounts hca
1443: WHERE hca.party_id = hp.party_id
1444: AND hca.cust_account_id = c_customer_id;
1445:
1446: l_operating_unit NUMBER;
2925: CURSOR c_cust_name(c_customer_id IN NUMBER)
2926: IS
2927: SELECT HP.PARTY_NAME
2928: FROM HZ_PARTIES HP,
2929: HZ_CUST_ACCOUNTS HCA
2930: WHERE HP.PARTY_ID = HCA.PARTY_ID
2931: AND HCA.CUST_ACCOUNT_ID = c_customer_id;
2932:
2933: CURSOR c_cust_site_location(c_site_use_id IN NUMBER)