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.JE_ES_WHTAX dependencies on GL_PERIOD_STATUSES

Line 709: from ap_invoice_distributions dist1, gl_period_statuses gl

705: and dist.invoice_line_number = line.line_number
706: -----and inv.cancelled_date is null -- Bug 2228008 )
707: AND dist.parent_reversal_id is null
708: AND not exists ( select 1
709: from ap_invoice_distributions dist1, gl_period_statuses gl
710: where gl.application_id = 101
711: and dist1.invoice_id = inv.invoice_id
712: and dist1.parent_reversal_id = dist.invoice_distribution_id
713: and gl.ledger_id = dist1.set_of_books_id

Line 793: from gl_period_statuses gl

789: /*AND inv.cancelled_date is not null
790: AND (
791: (dist.cancellation_flag is null
792: AND dist.accounting_date < (select distinct gl.start_date
793: from gl_period_statuses gl
794: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
795: from ap_invoice_distributions_all dist1
796: where dist1.invoice_id = inv.invoice_id
797: and dist1.cancellation_flag = 'Y' )))

Line 801: from gl_period_statuses gl

797: and dist1.cancellation_flag = 'Y' )))
798: OR
799: (dist.cancellation_flag = 'Y'
800: AND dist.accounting_date > (select distinct gl.end_date
801: from gl_period_statuses gl
802: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
803: from ap_invoice_distributions_all dist1
804: where dist1.invoice_id = inv.invoice_id
805: and dist1.cancellation_flag is null )))

Line 814: from ap_invoice_distributions dist1, gl_period_statuses gl

810: --
811: */
812: AND dist.parent_reversal_id is not null
813: AND dist.accounting_date > (select distinct gl.end_date
814: from ap_invoice_distributions dist1, gl_period_statuses gl
815: where gl.application_id = 101
816: and dist1.invoice_id = inv.invoice_id
817: and dist.parent_reversal_id = dist1.invoice_distribution_id
818: and gl.ledger_id = dist1.set_of_books_id

Line 922: from ap_invoice_distributions dist1, gl_period_statuses gl

918: and dist.invoice_line_number = line.line_number
919: ---and inv.cancelled_date is null -- Bug 2228008
920: AND dist.parent_reversal_id is null
921: AND not exists ( select 1
922: from ap_invoice_distributions dist1, gl_period_statuses gl
923: where gl.application_id = 101
924: and dist1.invoice_id = inv.invoice_id
925: and dist1.parent_reversal_id = dist.invoice_distribution_id
926: and gl.ledger_id = dist1.set_of_books_id

Line 1072: from gl_period_statuses gl

1068: /*AND inv.cancelled_date is not null
1069: AND (
1070: (dist.cancellation_flag is null
1071: AND dist.accounting_date < (select distinct gl.start_date
1072: from gl_period_statuses gl
1073: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1074: from ap_invoice_distributions_all dist1
1075: where dist1.invoice_id = inv.invoice_id
1076: and dist1.cancellation_flag = 'Y' )))

Line 1080: from gl_period_statuses gl

1076: and dist1.cancellation_flag = 'Y' )))
1077: OR
1078: (dist.cancellation_flag = 'Y'
1079: AND dist.accounting_date > (select distinct gl.end_date
1080: from gl_period_statuses gl
1081: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1082: from ap_invoice_distributions_all dist1
1083: where dist1.invoice_id = inv.invoice_id
1084: and dist1.cancellation_flag is null )))

Line 1090: from ap_invoice_distributions dist1, gl_period_statuses gl

1086: -- END
1087: */
1088: AND dist.parent_reversal_id is not null
1089: AND dist.accounting_date > (select distinct gl.end_date
1090: from ap_invoice_distributions dist1, gl_period_statuses gl
1091: where gl.application_id = 101
1092: and dist1.invoice_id = inv.invoice_id
1093: and dist.parent_reversal_id = dist1.invoice_distribution_id
1094: and gl.ledger_id = dist1.set_of_books_id

Line 1231: from ap_invoice_distributions dist1, gl_period_statuses gl

1227: and dist.invoice_line_number = line.line_number
1228: ---and inv.cancelled_date is null -- Bug 2228008
1229: AND dist.parent_reversal_id is null
1230: AND not exists ( select 1
1231: from ap_invoice_distributions dist1, gl_period_statuses gl
1232: where gl.application_id = 101
1233: and dist1.invoice_id = inv.invoice_id
1234: and dist1.parent_reversal_id = dist.invoice_distribution_id
1235: and gl.ledger_id = dist1.set_of_books_id

Line 1348: from gl_period_statuses gl

1344: AND
1345: (
1346: (dist.cancellation_flag is null
1347: AND dist.accounting_date < (select distinct gl.start_date
1348: from gl_period_statuses gl
1349: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1350: from ap_invoice_distributions_all dist1
1351: where dist1.invoice_id = inv.invoice_id
1352: and dist1.cancellation_flag = 'Y' )))

Line 1356: from gl_period_statuses gl

1352: and dist1.cancellation_flag = 'Y' )))
1353: OR
1354: (dist.cancellation_flag = 'Y'
1355: AND dist.accounting_date > (select distinct gl.end_date
1356: from gl_period_statuses gl
1357: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1358: from ap_invoice_distributions_all dist1
1359: where dist1.invoice_id = inv.invoice_id
1360: and dist1.cancellation_flag is null )))

Line 1366: from ap_invoice_distributions dist1, gl_period_statuses gl

1362: -- END
1363: */
1364: AND dist.parent_reversal_id is not null
1365: AND dist.accounting_date > (select distinct gl.end_date
1366: from ap_invoice_distributions dist1, gl_period_statuses gl
1367: where gl.application_id = 101
1368: and dist1.invoice_id = inv.invoice_id
1369: and dist.parent_reversal_id = dist1.invoice_distribution_id
1370: and gl.ledger_id = dist1.set_of_books_id

Line 1475: from ap_invoice_distributions dist1, gl_period_statuses gl

1471: and dist.invoice_line_number = line.line_number
1472: ---and inv.cancelled_date is null -- Bug 2228008
1473: AND dist.parent_reversal_id is null
1474: AND not exists ( select 1
1475: from ap_invoice_distributions dist1, gl_period_statuses gl
1476: where gl.application_id = 101
1477: and dist1.invoice_id = inv.invoice_id
1478: and dist1.parent_reversal_id = dist.invoice_distribution_id
1479: and gl.ledger_id = dist1.set_of_books_id

Line 1622: from gl_period_statuses gl

1618: AND
1619: (
1620: (dist.cancellation_flag is null
1621: AND dist.accounting_date < (select distinct gl.start_date
1622: from gl_period_statuses gl
1623: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1624: from ap_invoice_distributions_all dist1
1625: where dist1.invoice_id = inv.invoice_id
1626: and dist1.cancellation_flag = 'Y' )))

Line 1630: from gl_period_statuses gl

1626: and dist1.cancellation_flag = 'Y' )))
1627: OR
1628: (dist.cancellation_flag = 'Y'
1629: AND dist.accounting_date > (select distinct gl.end_date
1630: from gl_period_statuses gl
1631: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1632: from ap_invoice_distributions_all dist1
1633: where dist1.invoice_id = inv.invoice_id
1634: and dist1.cancellation_flag is null )))

Line 1640: from ap_invoice_distributions dist1, gl_period_statuses gl

1636: -- END
1637: */
1638: AND dist.parent_reversal_id is not null
1639: AND dist.accounting_date > (select distinct gl.end_date
1640: from ap_invoice_distributions dist1, gl_period_statuses gl
1641: where gl.application_id = 101
1642: and dist1.invoice_id = inv.invoice_id
1643: and dist.parent_reversal_id = dist1.invoice_distribution_id
1644: and gl.ledger_id = dist1.set_of_books_id

Line 1769: from ap_invoice_distributions dist1, gl_period_statuses gl

1765: and dist.invoice_line_number = line.line_number
1766: ---and inv.cancelled_date is null -- Bug 2228008
1767: AND dist.parent_reversal_id is null
1768: AND not exists ( select 1
1769: from ap_invoice_distributions dist1, gl_period_statuses gl
1770: where gl.application_id = 101
1771: and dist1.invoice_id = inv.invoice_id
1772: and dist1.parent_reversal_id = dist.invoice_distribution_id
1773: and gl.ledger_id = dist1.set_of_books_id

Line 1877: from gl_period_statuses gl

1873: AND
1874: (
1875: (dist.cancellation_flag is null
1876: AND dist.accounting_date < (select distinct gl.start_date
1877: from gl_period_statuses gl
1878: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1879: from ap_invoice_distributions_all dist1
1880: where dist1.invoice_id = inv.invoice_id
1881: and dist1.cancellation_flag = 'Y' )))

Line 1885: from gl_period_statuses gl

1881: and dist1.cancellation_flag = 'Y' )))
1882: OR
1883: (dist.cancellation_flag = 'Y'
1884: AND dist.accounting_date > (select distinct gl.end_date
1885: from gl_period_statuses gl
1886: where gl.period_name IN (select distinct to_char(dist1.accounting_date,'MM-YY')
1887: from ap_invoice_distributions_all dist1
1888: where dist1.invoice_id = inv.invoice_id
1889: and dist1.cancellation_flag is null )))

Line 1895: from ap_invoice_distributions dist1, gl_period_statuses gl

1891: -- END
1892: */
1893: AND dist.parent_reversal_id is not null
1894: AND dist.accounting_date > (select distinct gl.end_date
1895: from ap_invoice_distributions dist1, gl_period_statuses gl
1896: where gl.application_id = 101
1897: and dist1.invoice_id = inv.invoice_id
1898: and dist.parent_reversal_id = dist1.invoice_distribution_id
1899: and gl.ledger_id = dist1.set_of_books_id