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.JA_CN_AR_RBD_EXPORT_PKG dependencies on GL_PERIODS

Line 1469: Gl_Periods Gp

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
1473: AND gir.gl_sl_link_id = ael.gl_sl_link_id

Line 1496: FROM Gl_Periods Gp1

1492: AND Gl.accounted_period_type = Gp.period_type
1493: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
1494: AND Gp.start_date BETWEEN
1495: (SELECT Gp1.Start_Date
1496: FROM Gl_Periods Gp1
1497: WHERE Gl.period_set_name = Gp1.period_set_name
1498: AND Gl.accounted_period_type = Gp1.period_type
1499: AND Gp1.period_name = pv_first_period) --parameter: pv_first_period
1500: AND (SELECT Gp2.Start_Date

Line 1501: FROM Gl_Periods Gp2

1497: WHERE Gl.period_set_name = Gp1.period_set_name
1498: AND Gl.accounted_period_type = Gp1.period_type
1499: AND Gp1.period_name = pv_first_period) --parameter: pv_first_period
1500: AND (SELECT Gp2.Start_Date
1501: FROM Gl_Periods Gp2
1502: WHERE Gl.period_set_name = Gp2.period_set_name
1503: AND Gl.accounted_period_type = Gp2.period_type
1504: AND Gp2.period_name = pv_first_period) --parameter: pv_first_period
1505: AND jeh.ledger_id = pn_ledger_id; --parameter: pn_ledger_id

Line 1796: FROM Gl_Periods Gp1

1792: AND Gd.ACCOUNT_CLASS = 'REC'
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

Line 1803: FROM Gl_Periods Gp2

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
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

Line 1819: Gl_Periods Gp

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
1823: AND Gd.ACCOUNT_CLASS = 'REC'

Line 1835: Gl_Periods Gp

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
1839: AND Gl.accounted_period_type = Gp.period_type

Line 1850: Gl_Periods Gp

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
1854: AND Gd.ACCOUNT_CLASS = 'REC'

Line 1866: Gl_Periods Gp

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
1870: AND Gl.accounted_period_type = Gp.period_type

Line 1930: Gl_Periods Gp,

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
1934: AND Rctlgd.ACCOUNT_CLASS = 'REC'

Line 1992: Gl_Periods Gp,

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
1996: --SLA condition

Line 2121: Gl_Periods Gp,

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
2125: AND Rctlgd.ACCOUNT_CLASS = 'REC'

Line 2221: Gl_Periods Gp

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
2225: AND Adj.Adjustment_Id = Ent.Source_Id_Int_1

Line 2422: FROM Gl_Ledgers Gl, Gl_Periods Gp

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

Line 2430: FROM Gl_Periods Gp1

2426: AND Gl.Ledger_Id = pn_ledger_id--parameter: pn_ledger_id
2427: AND Gp.Period_Name = pv_period_from--parameter: pv_period_from
2428: AND Gp.Start_Date =
2429: (SELECT MIN(Gp1.START_DATE)
2430: FROM Gl_Periods Gp1
2431: WHERE Gl.period_set_name = Gp1.period_set_name
2432: AND Gl.accounted_period_type = Gp1.period_type
2433: AND Gp1.period_year = Gp.period_year);
2434: IF lv_first_period_flag = 'Y'

Line 2439: FROM Gl_Ledgers Gl, Gl_Periods Gp

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

Line 2446: FROM Gl_Periods Gp1

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
2444: AND Gp.Start_Date =
2445: (SELECT MIN(Gp1.START_DATE)
2446: FROM Gl_Periods Gp1
2447: WHERE Gl.period_set_name = Gp1.period_set_name
2448: AND Gl.accounted_period_type = Gp1.period_type
2449: AND Gp1.period_year = Gp.period_year);
2450: EXCEPTION