[Home] [Help]
1464: XLA_AE_HEADERS aeh,
1465: JA_CN_CODE_COMBINATION_V jcc,
1466: HZ_CUST_ACCOUNTS cust,
1467: HZ_PARTIES part,
1468: Gl_Ledgers Gl,
1469: Gl_Periods Gp
1470: WHERE jeh.je_header_id = jel.je_header_id
1471: AND jeh.je_header_id = gir.je_header_id
1472: AND jel.je_line_num = gir.je_line_num
1516:
1517: BEGIN
1518: SELECT Fcv.NAME Functional_Currency
1519: INTO lv_fun_currency
1520: FROM Gl_Ledgers Gl, Fnd_Currencies_Vl Fcv
1521: WHERE Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1522: AND Fcv.CURRENCY_CODE = Gl.Currency_Code;
1523: EXCEPTION
1524: WHEN NO_DATA_FOUND THEN
1793: AND Gd.LATEST_REC_FLAG = 'Y'
1794: AND Gd.gl_date NOT BETWEEN
1795: (SELECT Gp1.Start_Date
1796: FROM Gl_Periods Gp1
1797: ,Gl_Ledgers Gl
1798: WHERE Gl.period_set_name = Gp1.period_set_name
1799: AND Gl.accounted_period_type = Gp1.period_type
1800: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1801: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
1800: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1801: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
1802: AND (SELECT Gp2.End_Date
1803: FROM Gl_Periods Gp2
1804: ,Gl_Ledgers Gl
1805: WHERE Gl.period_set_name = Gp2.period_set_name
1806: AND Gl.accounted_period_type = Gp2.period_type
1807: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1808: AND Gp2.period_name = pv_period_to); --parameter: pv_period_to
1814: --from Transaction
1815: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1816: FROM RA_CUSTOMER_TRX_ALL Rct,
1817: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,
1818: Gl_Ledgers Gl,
1819: Gl_Periods Gp
1820: WHERE Rct.Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1821: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1822: AND Rct.CUSTOMER_TRX_ID = Gd.CUSTOMER_TRX_ID
1830: UNION
1831: --for Receipts from AR_RECEIVABLE_APPLICATIONS_ALL and the status must be Applied
1832: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1833: FROM AR_RECEIVABLE_APPLICATIONS_ALL App,
1834: Gl_Ledgers Gl,
1835: Gl_Periods Gp
1836: WHERE App.Applied_Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1837: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1838: AND Gl.period_set_name = Gp.period_set_name
1845: --from Credit Memo
1846: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1847: FROM RA_CUSTOMER_TRX_ALL Rct,
1848: RA_CUST_TRX_LINE_GL_DIST_ALL Gd,
1849: Gl_Ledgers Gl,
1850: Gl_Periods Gp
1851: WHERE Rct.Previous_Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1852: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1853: AND Rct.CUSTOMER_TRX_ID = Gd.CUSTOMER_TRX_ID
1861: UNION
1862: --from adjustment
1863: SELECT DISTINCT Gp.Period_Name,Gp.Start_Date,Gp.End_Date
1864: FROM AR_ADJUSTMENTS_ALL Adj,
1865: Gl_Ledgers Gl,
1866: Gl_Periods Gp
1867: WHERE Adj.Customer_Trx_Id = ln_customer_trx_id --variable: ln_customer_trx_id
1868: AND Gl.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1869: AND Gl.period_set_name = Gp.period_set_name
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Gl_Import_References Gir,
1928: Gl_Je_Headers Jeh,
1929: Gl_Ledgers Gl,
1930: Gl_Periods Gp,
1931: fnd_currencies_vl Fcv
1932: WHERE Rct.customer_trx_id = ln_customer_trx_id --variable: ln_customer_trx_id
1933: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
1987: Xla_Ae_Headers Aeh,
1988: Xla_Ae_Lines Ael,
1989: Gl_Je_Headers Jeh,
1990: Gl_Import_References Gir,
1991: Gl_Ledgers Gl,
1992: Gl_Periods Gp,
1993: fnd_currencies_vl Fcv
1994: WHERE Acr.Cash_Receipt_Id = App.Cash_Receipt_Id
1995: AND App.Applied_Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
2116: Xla_Ae_Headers Aeh,
2117: Xla_Ae_Lines Ael,
2118: Gl_Import_References Gir,
2119: Gl_Je_Headers Jeh,
2120: Gl_Ledgers Gl,
2121: Gl_Periods Gp,
2122: fnd_currencies_vl fcv
2123: WHERE Rct.Previous_Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
2124: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
2216: Xla_Ae_Headers Aeh,
2217: Xla_Ae_Lines Ael,
2218: Gl_Import_References Gir,
2219: Gl_Je_Headers Jeh,
2220: Gl_Ledgers Gl,
2221: Gl_Periods Gp
2222: WHERE Adj.Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
2223: --SLA condition
2224: AND Ent.Application_Id = 222
2418: 0,
2419: 'N', --Not first period, in this case, year begnning balance would not be exported
2420: 'Y')--It is first period and year beginning balance should be exported
2421: INTO lv_first_period_flag
2422: FROM Gl_Ledgers Gl, Gl_Periods Gp
2423: WHERE Gl.period_set_name = Gp.period_set_name
2424: AND Gl.accounted_period_type = Gp.period_type
2425: AND Gp.period_year = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
2426: AND Gl.Ledger_Id = pn_ledger_id--parameter: pn_ledger_id
2435: THEN
2436: BEGIN
2437: SELECT Gp.Period_Name, Gp.Period_Num
2438: INTO lv_first_period_name, ln_first_period_num
2439: FROM Gl_Ledgers Gl, Gl_Periods Gp
2440: WHERE Gl.period_set_name = Gp.period_set_name
2441: AND Gl.accounted_period_type = Gp.period_type
2442: AND Gp.period_year = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
2443: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2557: INTO lv_functional_currency
2558: FROM fnd_currencies_vl
2559: WHERE currency_code =
2560: (SELECT currency_code
2561: FROM gl_ledgers
2562: WHERE ledger_id = pn_ledger_id);
2563:
2564: --logging the variables
2565: IF (ln_statement_level >= ln_dbg_level)