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 1309: ,xla_subledgers xs

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

Line 1367: ,xla_subledgers xs

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

Line 1427: ,xla_subledgers xs

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

Line 1485: ,xla_subledgers xs

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

Line 1533: ,xla_subledgers xs

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

Line 1582: ,xla_subledgers xs

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

Line 1636: ,xla_subledgers xs

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

Line 1680: ,xla_subledgers xs

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

Line 1726: ,xla_subledgers xs

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

Line 1771: ,xla_subledgers xs

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

Line 1806: ,xla_subledgers xs

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

Line 1841: ,xla_subledgers xs

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