eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on XLE_JURISDICTIONS_VL

Line 1588: xle_jurisdictions_vl jur

1584:
1585: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789')
1586: INTO l_cnpj
1587: FROM xle_registrations reg,
1588: xle_jurisdictions_vl jur
1589: WHERE reg.source_id = g_legal_entity_id
1590: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1591: AND reg.jurisdiction_id = jur.jurisdiction_id
1592: AND jur.registration_code_le = 'CNPJ'

Line 1615: xle_jurisdictions_vl jur

1611: BEGIN --Retrieving state inscription
1612: SELECT registration_number
1613: INTO l_state_inscription
1614: FROM xle_registrations reg,
1615: xle_jurisdictions_vl jur
1616: WHERE reg.source_id = g_legal_entity_id
1617: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1618: AND reg.jurisdiction_id = jur.jurisdiction_id
1619: AND jur.registration_code_le = g_le_state_reg_code

Line 1635: xle_jurisdictions_vl jur

1631: BEGIN -- --Retrieving municipal inscription
1632: SELECT registration_number
1633: INTO l_municipal_inscription
1634: FROM xle_registrations reg,
1635: xle_jurisdictions_vl jur
1636: WHERE reg.source_id = g_legal_entity_id
1637: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1638: AND reg.jurisdiction_id = jur.jurisdiction_id
1639: AND jur.registration_code_le = g_le_municipal_reg_code

Line 1740: xle_jurisdictions_vl jur

1736: --retrieving cnpj
1737: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789')
1738: INTO l_cnpj
1739: FROM xle_registrations reg,
1740: xle_jurisdictions_vl jur
1741: WHERE reg.source_id = g_establishment_id
1742: AND reg.source_table = 'XLE_ETB_PROFILES'
1743: AND reg.jurisdiction_id = jur.jurisdiction_id
1744: AND jur.registration_code_etb = 'CNPJ'

Line 1769: xle_jurisdictions_vl jur

1765: BEGIN
1766: SELECT registration_number
1767: INTO l_state_inscription
1768: FROM xle_registrations reg,
1769: xle_jurisdictions_vl jur
1770: WHERE reg.source_id = g_establishment_id
1771: AND reg.source_table = 'XLE_ETB_PROFILES'
1772: AND reg.jurisdiction_id = jur.jurisdiction_id
1773: AND jur.registration_code_etb = g_le_state_reg_code

Line 1789: xle_jurisdictions_vl jur

1785: BEGIN --Retrieving municipal inscription
1786: SELECT registration_number
1787: INTO l_municipal_inscription
1788: FROM xle_registrations reg,
1789: xle_jurisdictions_vl jur
1790: WHERE reg.source_id = g_establishment_id
1791: AND reg.source_table = 'XLE_ETB_PROFILES'
1792: AND reg.jurisdiction_id = jur.jurisdiction_id
1793: AND jur.registration_code_etb = g_le_municipal_reg_code

Line 2209: xle_jurisdictions_vl jur

2205:
2206: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789')
2207: INTO l_cnpj
2208: FROM xle_registrations reg,
2209: xle_jurisdictions_vl jur
2210: WHERE reg.source_id = g_legal_entity_id
2211: AND reg.source_table = 'XLE_ENTITY_PROFILES'
2212: AND reg.jurisdiction_id = jur.jurisdiction_id
2213: AND jur.registration_code_le = 'CNPJ'

Line 2268: xle_jurisdictions_vl jur

2264: BEGIN
2265: SELECT registration_number
2266: INTO l_nire
2267: FROM xle_registrations reg,
2268: xle_jurisdictions_vl jur
2269: WHERE source_id = g_legal_entity_id
2270: AND source_table = 'XLE_ENTITY_PROFILES'
2271: AND reg.jurisdiction_id = jur.jurisdiction_id
2272: AND jur.legislative_cat_code = 'COMMERCIAL_LAW'

Line 2294: xle_jurisdictions_vl jur

2290: BEGIN
2291: SELECT registration_number
2292: INTO l_state_inscription
2293: FROM xle_registrations reg,
2294: xle_jurisdictions_vl jur
2295: WHERE reg.source_id = g_legal_entity_id
2296: AND reg.source_table = 'XLE_ENTITY_PROFILES'
2297: AND reg.jurisdiction_id = jur.jurisdiction_id
2298: AND jur.registration_code_le = g_le_state_reg_code

Line 2314: xle_jurisdictions_vl jur

2310: BEGIN -- --Retrieving municipal inscription
2311: SELECT registration_number
2312: INTO l_municipal_inscription
2313: FROM xle_registrations reg,
2314: xle_jurisdictions_vl jur
2315: WHERE reg.source_id = g_legal_entity_id
2316: AND reg.source_table = 'XLE_ENTITY_PROFILES'
2317: AND reg.jurisdiction_id = jur.jurisdiction_id
2318: AND jur.registration_code_le = g_le_municipal_reg_code

Line 2527: xle_jurisdictions_vl jur

2523: BEGIN
2524: SELECT registration_number
2525: INTO l_nire
2526: FROM xle_registrations reg,
2527: xle_jurisdictions_vl jur
2528: WHERE source_id = l_establishment_id
2529: AND source_table = 'XLE_ETB_PROFILES'
2530: AND reg.jurisdiction_id = jur.jurisdiction_id
2531: AND jur.legislative_cat_code = 'COMMERCIAL_LAW'

Line 2552: xle_jurisdictions_vl jur

2548: --retrieving cnpj
2549: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789')
2550: INTO l_cnpj
2551: FROM xle_registrations reg,
2552: xle_jurisdictions_vl jur
2553: WHERE reg.source_id = l_establishment_id
2554: AND reg.source_table = 'XLE_ETB_PROFILES'
2555: AND reg.jurisdiction_id = jur.jurisdiction_id
2556: AND jur.registration_code_etb = 'CNPJ'

Line 2581: xle_jurisdictions_vl jur

2577: BEGIN
2578: SELECT registration_number
2579: INTO l_state_inscription
2580: FROM xle_registrations reg,
2581: xle_jurisdictions_vl jur
2582: WHERE reg.source_id = l_establishment_id
2583: AND reg.source_table = 'XLE_ETB_PROFILES'
2584: AND reg.jurisdiction_id = jur.jurisdiction_id
2585: AND jur.registration_code_etb = g_le_state_reg_code

Line 2601: xle_jurisdictions_vl jur

2597: BEGIN --Retrieving municipal inscription
2598: SELECT registration_number
2599: INTO l_municipal_inscription
2600: FROM xle_registrations reg,
2601: xle_jurisdictions_vl jur
2602: WHERE reg.source_id = l_establishment_id
2603: AND reg.source_table = 'XLE_ETB_PROFILES'
2604: AND reg.jurisdiction_id = jur.jurisdiction_id
2605: AND jur.registration_code_etb = g_le_municipal_reg_code

Line 3387: xle_jurisdictions_vl jur

3383: BEGIN
3384: SELECT registration_number
3385: INTO l_nire
3386: FROM xle_registrations reg,
3387: xle_jurisdictions_vl jur
3388: WHERE source_id = g_legal_entity_id
3389: AND source_table = 'XLE_ENTITY_PROFILES'
3390: AND reg.jurisdiction_id = jur.jurisdiction_id
3391: AND jur.legislative_cat_code = 'COMMERCIAL_LAW'

Line 3434: xle_jurisdictions_vl jur

3430:
3431: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789'),reg.registration_id
3432: INTO l_cnpj,l_registration_id
3433: FROM xle_registrations reg,
3434: xle_jurisdictions_vl jur
3435: WHERE reg.source_id = g_legal_entity_id
3436: AND reg.source_table = 'XLE_ENTITY_PROFILES'
3437: AND reg.jurisdiction_id = jur.jurisdiction_id
3438: AND jur.registration_code_le = 'CNPJ'

Line 3549: xle_jurisdictions_vl jur

3545: BEGIN
3546: SELECT registration_number
3547: INTO l_nire
3548: FROM xle_registrations reg,
3549: xle_jurisdictions_vl jur
3550: WHERE source_id = g_establishment_id
3551: AND source_table = 'XLE_ETB_PROFILES'
3552: AND reg.jurisdiction_id = jur.jurisdiction_id
3553: AND jur.legislative_cat_code = 'COMMERCIAL_LAW'

Line 3594: xle_jurisdictions_vl jur

3590:
3591: SELECT translate(reg.registration_number,'0123456789/-.', '0123456789'),reg.registration_id
3592: INTO l_cnpj,l_registration_id
3593: FROM xle_registrations reg,
3594: xle_jurisdictions_vl jur
3595: WHERE reg.source_id = g_establishment_id
3596: AND reg.source_table = 'XLE_ETB_PROFILES'
3597: AND reg.jurisdiction_id = jur.jurisdiction_id
3598: AND jur.registration_code_le = 'CNPJ'