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.AR_UPGRADE_CASH_ACCRUAL dependencies on AR_ADJUSTMENTS

Line 134: FROM ar_adjustments_all adj

130: AND evt.event_id = app.event_id
131: AND app.status = 'APP'
132: AND app.upgrade_method IS NULL
133: AND EXISTS (SELECT '1'
134: FROM ar_adjustments_all adj
135: WHERE adj.customer_trx_id = app.applied_customer_trx_id
136: AND adj.upgrade_method = '11I'
137: AND adj.status = 'A'
138: AND adj.postable = 'Y'));

Line 689: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

685: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
686: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
687: AND ctlgd.account_set_flag = 'N'
688: AND ctl.customer_trx_line_id = taxx.link_to_cust_trx_line_id(+)
689: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
690: WHERE adj.customer_trx_id = app.applied_customer_trx_id
691: AND adj.upgrade_method = '11I'
692: AND adj.status = 'A'
693: AND adj.postable = 'Y');

Line 1334: FROM ar_adjustments adj,

1330: , NULL -- tax_inc_flag
1331: , ard.line_id -- ref_line_id
1332: , decode(adj.type, 'TAX', nvl(ard.tax_code_id, taxx.vat_tax_id), taxx.vat_tax_id)
1333: , decode(adj.type, 'TAX', nvl(ard.location_segment_id, taxx.location_segment_id), taxx.location_segment_id)
1334: FROM ar_adjustments adj,
1335: ar_distributions ard,
1336: ( select customer_trx_id, vat_tax_id, location_segment_id
1337: from ra_customer_trx_lines
1338: where customer_trx_id = p_trx_id

Line 1710: FROM ar_adjustments_all adj,

1706: , NULL -- tax_inc_flag
1707: , ard.line_id -- ref_line_id
1708: , ard.tax_code_id
1709: , ard.location_segment_id
1710: FROM ar_adjustments_all adj,
1711: ar_distributions_all ard,
1712: ar_system_parameters_all ars,
1713: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1714: MAX(to_currency) invoice_currency_code

Line 1940: FROM ar_adjustments_all adj,

1936: , NULL -- tax_link_id
1937: , NULL -- tax_inc_flag
1938: , NULL -- ref_line_id
1939: , 'Y' -- REF_MF_DIST_FLAG
1940: FROM ar_adjustments_all adj,
1941: psa_mf_adj_dist_all psad,
1942: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1943: MAX(to_currency) invoice_currency_code
1944: FROM ra_ar_gt

Line 2176: FROM ar_adjustments_all adj,

2172: , USERENV('SESSIONID') -- se_gt_id
2173: , NULL -- tax_link_id
2174: , NULL -- tax_inc_flag
2175: , NULL -- ref_line_id
2176: FROM ar_adjustments_all adj,
2177: ar_system_parameters_all ars,
2178: -- For performance this sql is not nec as for legacy data
2179: -- we are proposing no tied by to original line
2180: -- in new transaction the ref_line_id will be present

Line 2400: FROM ar_adjustments adj,

2396: , USERENV('SESSIONID') -- se_gt_id
2397: , NULL -- tax_link_id
2398: , NULL -- tax_inc_flag
2399: , NULL -- ref_line_id
2400: FROM ar_adjustments adj,
2401: ar_system_parameters_all ars,
2402: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2403: MAX(to_currency) invoice_currency_code
2404: FROM ra_ar_gt

Line 2599: FROM ar_adjustments_all adj

2595: AND evt.event_id = app.event_id
2596: AND app.status = 'APP'
2597: AND app.upgrade_method IS NULL
2598: AND EXISTS (SELECT '1'
2599: FROM ar_adjustments_all adj
2600: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2601: AND adj.upgrade_method = '11IMFAR'
2602: AND adj.status = 'A'
2603: AND adj.postable = 'Y')

Line 2616: FROM ar_adjustments_all adj

2612: AND evt.event_id = app.event_id
2613: AND app.status = 'APP'
2614: AND app.upgrade_method IS NULL
2615: AND EXISTS (SELECT '1'
2616: FROM ar_adjustments_all adj
2617: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2618: AND adj.upgrade_method = '11I'
2619: AND adj.status = 'A'
2620: AND adj.postable = 'Y');

Line 2655: FROM ar_adjustments_all adj

2651: AND app.upgrade_method IS NULL
2652: AND app.org_id = ars.org_id
2653: AND ars.accounting_method = 'CASH'
2654: AND EXISTS (SELECT '1'
2655: FROM ar_adjustments_all adj
2656: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2657: AND adj.upgrade_method = '11I'
2658: AND adj.status = 'A'
2659: AND adj.postable = 'Y');

Line 2876: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

2872: 'CM_CREATE' ,'CM_UPDATE' )
2873: AND evt.event_id = app.event_id
2874: AND app.status = 'APP'
2875: AND app.upgrade_method IS NULL
2876: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2877: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2878: AND adj.upgrade_method = '11IMFAR'
2879: AND adj.status = 'A'
2880: AND adj.postable = 'Y')

Line 2891: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

2887: 'CM_CREATE' ,'CM_UPDATE' )
2888: AND evt.event_id = app.event_id
2889: AND app.status = 'APP'
2890: AND app.upgrade_method IS NULL
2891: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2892: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2893: AND adj.upgrade_method = '11I'
2894: AND adj.status = 'A'
2895: AND adj.postable = 'Y');

Line 2906: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

2902: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2903: AND evt.event_id = app.event_id
2904: AND app.status = 'APP'
2905: AND app.upgrade_method IS NULL
2906: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2907: WHERE adj.customer_trx_id = app.customer_trx_id
2908: AND adj.upgrade_method = '11IMFAR'
2909: AND adj.status = 'A'
2910: AND adj.postable = 'Y')

Line 2919: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

2915: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2916: AND evt.event_id = app.event_id
2917: AND app.status = 'APP'
2918: AND app.upgrade_method IS NULL
2919: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2920: WHERE adj.customer_trx_id = app.customer_trx_id
2921: AND adj.upgrade_method = '11I'
2922: AND adj.status = 'A'
2923: AND adj.postable = 'Y');

Line 3349: FROM ar_adjustments_all adj

3345: AND evt.event_id = app.event_id
3346: AND app.status = 'APP'
3347: AND app.upgrade_method IS NULL
3348: AND EXISTS (SELECT '1'
3349: FROM ar_adjustments_all adj
3350: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3351: AND adj.upgrade_method = '11IMFAR'
3352: AND adj.status = 'A'
3353: AND adj.postable = 'Y')

Line 3365: FROM ar_adjustments_all adj

3361: AND evt.event_id = app.event_id
3362: AND app.status = 'APP'
3363: AND app.upgrade_method IS NULL
3364: AND EXISTS (SELECT '1'
3365: FROM ar_adjustments_all adj
3366: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3367: AND adj.upgrade_method = '11I'
3368: AND adj.status = 'A'
3369: AND adj.postable = 'Y')

Line 3398: FROM ar_adjustments_all adj

3394: AND app.status = 'APP'
3395: AND app.upgrade_method IS NULL
3396: -- AND app.cash_receipt_id = cr.cash_receipt_id(+)
3397: AND EXISTS (SELECT '1'
3398: FROM ar_adjustments_all adj
3399: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3400: AND adj.upgrade_method = '11I'
3401: AND adj.status = 'A'
3402: AND adj.postable = 'Y'));