APPS.JE_ES_MODELO_EXT_PKG dependencies on FND_TERRITORIES

Line 42: , fnd_territories FT

38: SUBSTR(assa.address_line2,1,35)||' '||
39: SUBSTR(assa.address_line3,1,35) ADDRESS_DETAIL
40: , assa.country
41: FROM ap_supplier_sites_all assa
42: , fnd_territories FT
43: WHERE assa.vendor_site_id = p_party_site_id
44: AND assa.country(+) = FT.territory_code;
45:
46: BEGIN

Line 439: , fnd_territories FT

435: NVL(LENGTH(LTRIM(TRANSLATE(HL.ADDRESS3, '123456789','000000000'),'0')),0)),5,'0') address_detail
436: FROM hz_cust_acct_sites_all HCAS
437: , hz_party_sites HPS
438: , hz_locations HL --12656346
439: , fnd_territories FT
440: , hz_cust_site_uses_all HCSU
441: WHERE HCAS.cust_acct_site_id = p_customer_address_id
442: AND HPS.party_site_id = HCAS.party_site_id
443: AND HL.location_id = HPS.location_id

Line 484: , fnd_territories FT

480: , HL.country
481: FROM hz_cust_acct_sites_all HCAS
482: , hz_party_sites HPS
483: , hz_locations HL
484: , fnd_territories FT
485: , hz_cust_site_uses_all HCSU
486: WHERE HCAS.cust_acct_site_id = p_customer_address_id
487: AND HPS.party_site_id = HCAS.party_site_id
488: AND HL.location_id = HPS.location_id

Line 648: -- , fnd_territories FT -- Bug 8485057: not necessary

644: , jg_zz_vat_trx_details JZVTD
645: , hz_cust_acct_sites_all HCAS
646: , hz_party_sites HPS
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary
649: , hz_cust_site_uses_all HCSU
650: , zx_lines_det_factors ZXDF
651: , ra_customer_trx TRX
652: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1220: , fnd_territories FT

1216: FROM JG_ZZ_VAT_TRX_GT JVGT
1217: , hz_cust_acct_sites_all HCAS
1218: , hz_party_sites HPS
1219: , hz_locations HL
1220: , fnd_territories FT
1221: , hz_cust_site_uses_all HCSU
1222: WHERE JVGT.jg_info_n3 = p_customer_id
1223: AND HCAS.cust_acct_site_id = JVGT.jg_info_n2
1224: AND HPS.party_site_id = HCAS.party_site_id