JL Colombian Magnetic Media Literals and Third Party Movement Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Latin America Localizations
- Source
- Colombian Magnetic Media Literals and Third Party Movement Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- JLCOGLNM_XML
- DB package
- JL_JLCOGLNM_XMLP_PKG
Imported from BI Publisher
Colombian Magnetic Media Literals and Third Party Movement Report
Colombian Magnetic Media Literals and Third Party Movement Report
SQL 29 lines
SELECT TO_CHAR(mglit.literal_code) literal , DECODE(n.type, 'FOREIGN_ENTITY', '444444444', n.nit) nit , l.meaning id_type , mgl.reported_value reported_val , mgl.third_party_name nit_name , mgl.first_reported_value first_val , mgl.second_reported_value second_val --JL_JLCOGLNM_XMLP_PKG.cf_totalformula(:CS_rep_firstval, :CS_rep_secondval) CF_total FROM jl_co_gl_mg_literals mglit , FND_LOOKUPS l , jl_co_gl_nits n , jl_co_gl_mg_lines mgl , jl_co_gl_mg_headers mgh WHERE mgh.set_of_books_id = :P_SOB_ID AND mgh.reported_year = :P_REPORTED_YEAR AND mgh.mg_header_id = mgl.mg_header_id AND mgl.reported_flag = 'Y' AND mgl.nit_id = n.nit_id AND n.type = l.lookup_code AND l.lookup_type = 'JLCO_TAXID_TYPE' AND mgl.literal_id = mglit.literal_id AND TO_CHAR(mglit.literal_code) BETWEEN :P_LITERAL_START1 AND :P_LITERAL_END1 ORDER BY mglit.literal_code, n.nit |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Legal Entity | LOV Oracle | |
| Reported Year | LOV Oracle | |
| Literal Start | LOV Oracle | |
| Literal End | LOV Oracle |