APPS.JE_ES_MODELO_EXT_PKG dependencies on FND_TERRITORIES

Line 40: , fnd_territories FT

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

Line 70: , fnd_territories FT

66: NVL(LENGTH(LTRIM(TRANSLATE(HL.address_line_3, '123456789','000000000'),'0')),0)),5,'0') address_detail
67: FROM hz_cust_acct_sites_all HCAS
68: , hz_party_sites HPS
69: , hr_locations HL
70: , fnd_territories FT
71: , hz_cust_site_uses_all HCSU
72: WHERE HCAS.cust_acct_site_id = p_customer_address_id
73: AND HPS.party_site_id = HCAS.party_site_id
74: AND HL.location_id = HPS.location_id

Line 109: , fnd_territories FT

105: , SUBSTR(HL.address3||'Z',1,INSTR(HL.address3||'Z',
106: LTRIM(HL.address3||'Z','1234567890')) - 1) numero FROM hz_cust_acct_sites_all HCAS
107: , hz_party_sites HPS
108: , hz_locations HL
109: , fnd_territories FT
110: , hz_cust_site_uses_all HCSU
111: WHERE HCAS.cust_acct_site_id = p_customer_address_id
112: AND HPS.party_site_id = HCAS.party_site_id
113: AND HL.location_id = HPS.location_id

Line 164: , fnd_territories FT

160: , jg_zz_vat_trx_details JZVTD
161: , hz_cust_acct_sites_all HCAS
162: , hz_party_sites HPS
163: , hr_locations HL
164: , fnd_territories FT
165: , hz_cust_site_uses_all HCSU
166: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
167: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
168: AND JZVTD.extract_source_ledger = 'AR'

Line 620: , fnd_territories FT

616: FROM JG_ZZ_VAT_TRX_GT JVGT
617: , hz_cust_acct_sites_all HCAS
618: , hz_party_sites HPS
619: , hz_locations HL
620: , fnd_territories FT
621: , hz_cust_site_uses_all HCSU
622: WHERE JVGT.jg_info_n3 = p_customer_id
623: AND HCAS.cust_acct_site_id = JVGT.jg_info_n2
624: AND HPS.party_site_id = HCAS.party_site_id

Line 653: --, fnd_territories FT

649: FROM JG_ZZ_VAT_TRX_DETAILS JVGT, JG_ZZ_VAT_REP_STATUS JZVRS
650: --, hz_cust_acct_sites_all HCAS
651: --, hz_party_sites HPS
652: --, hz_locations HL
653: --, fnd_territories FT
654: , hz_cust_site_uses_all HCSU
655: WHERE JVGT.billing_trading_partner_id = p_customer_id
656: --AND HCAS.cust_acct_site_id = JVGT.billing_tp_address_id
657: --AND HPS.party_site_id = HCAS.party_site_id