[Home] [Help]
342: , lkp.meaning
343: , loc.location_type_lookup_code
344: , loc.location_id
345: FROM pn_locations_all loc
346: , fnd_lookups lkp
347: WHERE loc.status = 'A'
348: --AND loc.org_id = g_org_id
349: AND loc.org_id = fnd_global.org_id
350: AND loc.location_type_lookup_code = lkp.lookup_code
399: , lkp.meaning
400: , loc.location_type_lookup_code
401: , loc.location_id
402: FROM pn_locations_all loc
403: , fnd_lookups lkp
404: WHERE loc.status = 'A'
405: AND loc.org_id = p_org_id
406: AND loc.location_type_lookup_code = lkp.lookup_code
407: AND loc.location_id = x_location_id
1688: CURSOR c_customer_billtosite_use_id
1689: IS
1690:
1691: SELECT hcsu.site_use_id customer_billtosite_use_id
1692: FROM fnd_lookups flo,
1693: hz_cust_site_uses_all hcsu,
1694: hz_cust_acct_sites_all hcas,
1695: hz_party_sites hps,
1696: hz_locations hlc,
2407:
2408: CURSOR c_customer_site
2409: IS
2410: SELECT hcsu.site_use_id
2411: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
2412: WHERE hcas.cust_account_id = p_customer_id
2413: AND hcas.org_id = p_org_id
2414: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
2415: AND hcsu.org_id = hcas.org_id
2425:
2426: CURSOR c_customer_site_id
2427: IS
2428: SELECT hcsu.site_use_id
2429: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
2430: WHERE hcas.cust_account_id = p_customer_id
2431: AND hcas.org_id = p_org_id
2432: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
2433: AND hcsu.org_id = hcas.org_id