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.XLA_REPORTING_SEQUENCE_PKG dependencies on XLA_SUBLEDGERS

Line 341: , xla_subledgers xs

337: ,p_sort_date IN VARCHAR2 ) return boolean is
338: cursor c_gl_date is
339: SELECT 1
340: FROM gl_je_headers gjh
341: , xla_subledgers xs
342: WHERE gjh.ledger_id = p_ledger_id
343: AND gjh.period_name = p_period_name
344: AND gjh.status = 'P'
345: AND (gjh.parent_je_header_id is not null or xs.je_source_name is null)

Line 353: , xla_subledgers xs

349:
350: cursor c_ref_date is
351: SELECT 1
352: FROM gl_je_headers gjh
353: , xla_subledgers xs
354: WHERE ledger_id = p_ledger_id
355: AND period_name = p_period_name
356: AND gjh.status = 'P'
357: AND (gjh.parent_je_header_id is not null or xs.je_source_name is null)

Line 365: , xla_subledgers xs

361:
362: cursor c_comp_date is
363: SELECT 1
364: FROM gl_je_headers gjh
365: , xla_subledgers xs
366: WHERE ledger_id = p_ledger_id
367: AND period_name = p_period_name
368: AND gjh.status = 'P'
369: AND (gjh.parent_je_header_id is not null or xs.je_source_name is null)

Line 1311: ,xla_subledgers xs

1307: decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1308: ,gjh.posted_date
1309: FROM gl_je_headers gjh
1310: ,gl_period_statuses gps
1311: ,xla_subledgers xs
1312: WHERE gjh.ledger_id = p_ledger_id
1313: AND gjh.default_effective_date >= p_start_date
1314: AND gjh.default_effective_date < p_end_date
1315: AND gjh.status = 'P'

Line 1369: ,xla_subledgers xs

1365: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1366: ,gjh.posted_date
1367: FROM gl_je_headers gjh
1368: ,gl_period_statuses gps
1369: ,xla_subledgers xs
1370: WHERE gjh.ledger_id = p_ledger_id
1371: AND nvl(gjh.reference_date
1372: ,decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date
1373: AND nvl(gjh.reference_date

Line 1429: ,xla_subledgers xs

1425: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1426: ,gjh.posted_date
1427: FROM gl_je_headers gjh
1428: ,gl_period_statuses gps
1429: ,xla_subledgers xs
1430: WHERE gjh.ledger_id = p_ledger_id
1431: AND gjh.posted_date>= p_start_date
1432: AND gjh.posted_date< p_end_date
1433: AND gjh.status = 'P'

Line 1487: ,xla_subledgers xs

1483: ,xah.accounting_date
1484: ,nvl(xah.reference_date, xah.accounting_date)
1485: ,nvl(xah.completed_date, xah.accounting_date)
1486: FROM xla_ae_headers xah
1487: ,xla_subledgers xs
1488: WHERE xah.ledger_id = p_ledger_id
1489: AND xah.accounting_date >= p_start_date
1490: AND xah.accounting_date < p_end_date
1491: AND xah.accounting_entry_status_code = 'F'

Line 1535: ,xla_subledgers xs

1531: ,xah.accounting_date
1532: ,nvl(xah.reference_date, xah.accounting_date)
1533: ,nvl(xah.completed_date, xah.accounting_date)
1534: FROM xla_ae_headers xah
1535: ,xla_subledgers xs
1536: WHERE xah.ledger_id = p_ledger_id
1537: AND nvl(xah.reference_date, xah.accounting_date) >= p_start_date
1538: AND nvl(xah.reference_date, xah.accounting_date) < p_end_date
1539: AND xah.accounting_entry_status_code = 'F'

Line 1584: ,xla_subledgers xs

1580: ,nvl(xah.reference_date, xah.accounting_date)
1581: ,nvl(xah.completed_date, xah.accounting_date)
1582:
1583: FROM xla_ae_headers xah
1584: ,xla_subledgers xs
1585: WHERE xah.ledger_id = p_ledger_id
1586: AND nvl(xah.completed_date, xah.accounting_date) >= p_start_date
1587: AND nvl(xah.completed_date, xah.accounting_date) < p_end_date
1588: AND xah.accounting_entry_status_code = 'F'

Line 1638: ,xla_subledgers xs

1634: decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1635: ,gjh.posted_date
1636: FROM gl_je_headers gjh
1637: ,gl_period_statuses gps
1638: ,xla_subledgers xs
1639: WHERE gjh.ledger_id = p_ledger_id
1640: AND gjh.default_effective_date >= p_start_date
1641: AND gjh.default_effective_date < p_end_date
1642: AND gjh.status = 'P'

Line 1682: ,xla_subledgers xs

1678: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1679: ,gjh.posted_date
1680: FROM gl_je_headers gjh
1681: ,gl_period_statuses gps
1682: ,xla_subledgers xs
1683: WHERE gjh.ledger_id = p_ledger_id
1684: AND nvl(gjh.reference_date
1685: ,decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date
1686: AND nvl(gjh.reference_date

Line 1728: ,xla_subledgers xs

1724: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1725: ,gjh.posted_date
1726: FROM gl_je_headers gjh
1727: ,gl_period_statuses gps
1728: ,xla_subledgers xs
1729: WHERE gjh.ledger_id = p_ledger_id
1730: AND gjh.posted_date>= p_start_date
1731: AND gjh.posted_date< p_end_date
1732: AND gjh.status = 'P'

Line 1773: ,xla_subledgers xs

1769: ,nvl(xah.reference_date, xah.accounting_date)
1770: ,nvl(xah.completed_date, xah.accounting_date)
1771:
1772: FROM xla_ae_headers xah
1773: ,xla_subledgers xs
1774: WHERE xah.ledger_id = p_ledger_id
1775: AND xah.accounting_date >= p_start_date
1776: AND xah.accounting_date < p_end_date
1777: AND xah.accounting_entry_status_code = 'F'

Line 1808: ,xla_subledgers xs

1804: ,nvl(xah.reference_date, xah.accounting_date)
1805: ,nvl(xah.completed_date, xah.accounting_date)
1806:
1807: FROM xla_ae_headers xah
1808: ,xla_subledgers xs
1809: WHERE xah.ledger_id = p_ledger_id
1810: AND nvl(xah.reference_date, xah.accounting_date) >= p_start_date
1811: AND nvl(xah.reference_date, xah.accounting_date) < p_end_date
1812: AND xah.accounting_entry_status_code = 'F'

Line 1843: ,xla_subledgers xs

1839: ,nvl(xah.reference_date, xah.accounting_date)
1840: ,nvl(xah.completed_date, xah.accounting_date)
1841:
1842: FROM xla_ae_headers xah
1843: ,xla_subledgers xs
1844: WHERE xah.ledger_id = p_ledger_id
1845: AND nvl(xah.completed_date, xah.accounting_date)>= p_start_date
1846: AND nvl(xah.completed_date, xah.accounting_date) < p_end_date
1847: AND xah.accounting_entry_status_code = 'F'