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.FII_AR_FACTS_AGING_PKG dependencies on GL_SETS_OF_BOOKS

Line 575: gl_sets_of_books sob,

571: 'GL', trxsch.gl_date,
572: trxsch.trx_date) >= g_global_start_date
573: ) v,
574: ar_system_parameters_all par,
575: gl_sets_of_books sob,
576: fnd_currencies cur
577: WHERE v.org_id = par.org_id
578: AND par.set_of_books_id = sob.set_of_books_id
579: AND cur.currency_code = sob.currency_code

Line 920: GL_SETS_OF_BOOKS sob,

916: FROM AR_PAYMENT_SCHEDULES_ALL sch,
917: RA_CUSTOMER_TRX_ALL trx,
918: FII_AR_CURR_RATES_T rt,
919: AR_SYSTEM_PARAMETERS_ALL par,
920: GL_SETS_OF_BOOKS sob,
921: AR_TRANSACTION_HISTORY_ALL h,
922: RA_CUST_TRX_TYPES_ALL tp
923: WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR', 'PMT')
924: AND decode(g_collection_criteria,

Line 1064: GL_SETS_OF_BOOKS sob

1060: AR_RECEIVABLE_APPLICATIONS_ALL app,
1061: AR_PAYMENT_SCHEDULES_ALL trxsch,
1062: FII_AR_CURR_RATES_T rt,
1063: AR_SYSTEM_PARAMETERS_ALL par,
1064: GL_SETS_OF_BOOKS sob
1065: WHERE sch.class = 'PMT'
1066: AND sch.payment_schedule_id = app.payment_schedule_id
1067: AND app.applied_payment_schedule_id = trxsch.payment_schedule_id
1068: AND app.status = 'APP'

Line 1206: GL_SETS_OF_BOOKS sob

1202: FROM AR_DISPUTE_HISTORY dis,
1203: FII_AR_PMT_SCHEDULES_F sch,
1204: FII_AR_CURR_RATES_T rt,
1205: AR_SYSTEM_PARAMETERS_ALL par,
1206: GL_SETS_OF_BOOKS sob
1207: WHERE dis.payment_schedule_id = sch.payment_schedule_id
1208: AND sch.class <> 'PMT'
1209: AND dis.start_date <= sch.actual_date_closed
1210: AND dis.start_date >= g_global_start_date

Line 1515: GL_SETS_OF_BOOKS sob

1511: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
1512: RA_CUSTOMER_TRX_LINES_ALL line,
1513: FII_AR_CURR_RATES_T rt,
1514: AR_SYSTEM_PARAMETERS_ALL par,
1515: GL_SETS_OF_BOOKS sob
1516: WHERE adj.status = 'A'
1517: AND adj.customer_trx_id = trx.customer_trx_id
1518: /*AND adj.customer_trx_id = decode(trx.class,
1519: 'CM', trx.previous_customer_trx_id,

Line 1796: GL_SETS_OF_BOOKS sob

1792: --rct.customer_site_use_id
1793: from AR_CASH_RECEIPTS_ALL rct,
1794: FII_AR_CURR_RATES_T rctrt,
1795: AR_SYSTEM_PARAMETERS_ALL par,
1796: GL_SETS_OF_BOOKS sob
1797: where --rct.receipt_date >= g_global_start_date
1798: rct.org_id = par.org_id
1799: and par.set_of_books_id = sob.set_of_books_id
1800: and sob.currency_code = rctrt.fc_code

Line 1817: GL_SETS_OF_BOOKS sob

1813: trxsch.bill_to_site_use_id
1814: from FII_AR_PMT_SCHEDULES_F trxsch,
1815: FII_AR_CURR_RATES_T trxrt,
1816: AR_SYSTEM_PARAMETERS_ALL par,
1817: GL_SETS_OF_BOOKS sob
1818: where trxsch.org_id = par.org_id
1819: AND par.set_of_books_id = sob.set_of_books_id
1820: AND sob.currency_code = trxrt.fc_code
1821: AND trxrt.conversion_date = trunc(least(nvl(trxsch.exchange_date,

Line 1825: gl_sets_of_books sob

1821: AND trxrt.conversion_date = trunc(least(nvl(trxsch.exchange_date,
1822: trxsch.trx_date),sysdate))) trxsch,
1823: gl_periods per,
1824: ar_system_parameters_all par,
1825: gl_sets_of_books sob
1826:
1827: WHERE app.payment_schedule_id = rctsch.payment_schedule_id
1828: AND rctsch.class in ('PMT', 'CM')
1829: AND app.application_type IN ('CASH','CM')

Line 4831: gl_sets_of_books sob,

4827: --WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR','PMT')
4828: --AND sch.trx_date >= g_global_start_date
4829: ) v,
4830: ar_system_parameters_all par,
4831: gl_sets_of_books sob,
4832: fnd_currencies cur
4833: WHERE v.org_id = par.org_id
4834: AND par.set_of_books_id = sob.set_of_books_id
4835: AND cur.currency_code = sob.currency_code

Line 5047: GL_SETS_OF_BOOKS sob

5043: FROM FII_AR_PAYSCH_MERGE_GT sch,
5044: RA_CUSTOMER_TRX_ALL trx,
5045: FII_AR_CURR_RATES_T rt,
5046: AR_SYSTEM_PARAMETERS_ALL par,
5047: GL_SETS_OF_BOOKS sob
5048: WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR', 'PMT')
5049: /*AND decode(g_collection_criteria,
5050: 'GL', sch.gl_date,
5051: sch.trx_date) >= g_global_start_date */

Line 5374: GL_SETS_OF_BOOKS sob

5370: from FII_AR_PAYSCH_MERGE_GT sch
5371: ) sch,
5372: FII_AR_CURR_RATES_T rt,
5373: AR_SYSTEM_PARAMETERS_ALL par,
5374: GL_SETS_OF_BOOKS sob
5375: WHERE dis.payment_schedule_id = sch.payment_schedule_id
5376: AND sch.class <> 'PMT'
5377: AND dis.start_date <= sch.actual_date_closed
5378: AND dis.start_date >= g_global_start_date

Line 5616: GL_SETS_OF_BOOKS sob

5612: gl_date
5613: from FII_AR_PAYSCH_MERGE_GT sch,
5614: FII_AR_CURR_RATES_T rt,
5615: AR_SYSTEM_PARAMETERS_ALL par,
5616: GL_SETS_OF_BOOKS sob
5617: WHERE sch.org_id = par.org_id
5618: AND par.set_of_books_id = sob.set_of_books_id
5619: AND sob.currency_code = rt.fc_code
5620: AND trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) = rt.conversion_date

Line 5939: GL_SETS_OF_BOOKS sob

5935: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
5936: RA_CUSTOMER_TRX_LINES_ALL line,
5937: FII_AR_CURR_RATES_T rt,
5938: AR_SYSTEM_PARAMETERS_ALL par,
5939: GL_SETS_OF_BOOKS sob
5940: WHERE adj.status = 'A'
5941: AND adj.customer_trx_id = trx.customer_trx_id
5942: /*AND adj.customer_trx_id = decode(trx.class,
5943: 'CM', trx.previous_customer_trx_id,

Line 6308: GL_SETS_OF_BOOKS sob

6304: --rct.customer_site_use_id
6305: from AR_CASH_RECEIPTS_ALL rct,
6306: FII_AR_CURR_RATES_T rctrt,
6307: AR_SYSTEM_PARAMETERS_ALL par,
6308: GL_SETS_OF_BOOKS sob
6309: where --rct.receipt_date >= g_global_start_date
6310: rct.org_id = par.org_id
6311: and par.set_of_books_id = sob.set_of_books_id
6312: and sob.currency_code = rctrt.fc_code

Line 6340: GL_SETS_OF_BOOKS sob

6336: from FII_AR_PAYSCH_MERGE_GT sch
6337: ) trxsch,
6338: FII_AR_CURR_RATES_T trxrt,
6339: AR_SYSTEM_PARAMETERS_ALL par,
6340: GL_SETS_OF_BOOKS sob
6341: where trxsch.org_id = par.org_id
6342: AND par.set_of_books_id = sob.set_of_books_id
6343: AND sob.currency_code = trxrt.fc_code
6344: AND trxrt.conversion_date = trunc(least(nvl(trxsch.exchange_date,

Line 6349: gl_sets_of_books sob

6345: trxsch.trx_date),sysdate))) trxsch,
6346:
6347: gl_periods per,
6348: ar_system_parameters_all par,
6349: gl_sets_of_books sob
6350:
6351: WHERE app.payment_schedule_id = rctsch.payment_schedule_id
6352: AND rctsch.class in ('PMT', 'CM')
6353: AND app.application_type IN ('CASH','CM')