APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on AR_ADJUSTMENTS_ALL

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 663: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj

659: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
660: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
661: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
662: AND ctlgd.account_set_flag = 'N'
663: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
664: WHERE adj.customer_trx_id = app.applied_customer_trx_id
665: AND adj.upgrade_method = '11I'
666: AND adj.status = 'A'
667: AND adj.postable = 'Y');

Line 1512: FROM ar_adjustments_all adj,

1508: , USERENV('SESSIONID') -- se_gt_id
1509: , NULL -- tax_link_id
1510: , NULL -- tax_inc_flag
1511: , ard.line_id -- ref_line_id
1512: FROM ar_adjustments_all adj,
1513: ar_distributions_all ard,
1514: ar_system_parameters_all ars,
1515: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1516: MAX(to_currency) invoice_currency_code

Line 1742: FROM ar_adjustments_all adj,

1738: , NULL -- tax_link_id
1739: , NULL -- tax_inc_flag
1740: , NULL -- ref_line_id
1741: , 'Y' -- REF_MF_DIST_FLAG
1742: FROM ar_adjustments_all adj,
1743: psa_mf_adj_dist_all psad,
1744: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1745: MAX(to_currency) invoice_currency_code
1746: FROM ra_ar_gt

Line 1978: FROM ar_adjustments_all adj,

1974: , USERENV('SESSIONID') -- se_gt_id
1975: , NULL -- tax_link_id
1976: , NULL -- tax_inc_flag
1977: , NULL -- ref_line_id
1978: FROM ar_adjustments_all adj,
1979: ar_system_parameters_all ars,
1980: -- For performance this sql is not nec as for legacy data
1981: -- we are proposing no tied by to original line
1982: -- in new transaction the ref_line_id will be present

Line 2380: FROM ar_adjustments_all adj

2376: AND evt.event_id = app.event_id
2377: AND app.status = 'APP'
2378: AND app.upgrade_method IS NULL
2379: AND EXISTS (SELECT '1'
2380: FROM ar_adjustments_all adj
2381: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2382: AND adj.upgrade_method = '11IMFAR'
2383: AND adj.status = 'A'
2384: AND adj.postable = 'Y')

Line 2397: FROM ar_adjustments_all adj

2393: AND evt.event_id = app.event_id
2394: AND app.status = 'APP'
2395: AND app.upgrade_method IS NULL
2396: AND EXISTS (SELECT '1'
2397: FROM ar_adjustments_all adj
2398: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2399: AND adj.upgrade_method = '11I'
2400: AND adj.status = 'A'
2401: AND adj.postable = 'Y');

Line 2436: FROM ar_adjustments_all adj

2432: AND app.upgrade_method IS NULL
2433: AND app.org_id = ars.org_id
2434: AND ars.accounting_method = 'CASH'
2435: AND EXISTS (SELECT '1'
2436: FROM ar_adjustments_all adj
2437: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2438: AND adj.upgrade_method = '11I'
2439: AND adj.status = 'A'
2440: AND adj.postable = 'Y');

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

2653: 'CM_CREATE' ,'CM_UPDATE' )
2654: AND evt.event_id = app.event_id
2655: AND app.status = 'APP'
2656: AND app.upgrade_method IS NULL
2657: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2658: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2659: AND adj.upgrade_method = '11IMFAR'
2660: AND adj.status = 'A'
2661: AND adj.postable = 'Y')

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

2668: 'CM_CREATE' ,'CM_UPDATE' )
2669: AND evt.event_id = app.event_id
2670: AND app.status = 'APP'
2671: AND app.upgrade_method IS NULL
2672: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2673: WHERE adj.customer_trx_id = app.applied_customer_trx_id
2674: AND adj.upgrade_method = '11I'
2675: AND adj.status = 'A'
2676: AND adj.postable = 'Y');

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

2683: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2684: AND evt.event_id = app.event_id
2685: AND app.status = 'APP'
2686: AND app.upgrade_method IS NULL
2687: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2688: WHERE adj.customer_trx_id = app.customer_trx_id
2689: AND adj.upgrade_method = '11IMFAR'
2690: AND adj.status = 'A'
2691: AND adj.postable = 'Y')

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

2696: WHERE evt.event_type_code IN ('CM_CREATE','CM_UPDATE')
2697: AND evt.event_id = app.event_id
2698: AND app.status = 'APP'
2699: AND app.upgrade_method IS NULL
2700: AND EXISTS (SELECT '1' FROM ar_adjustments_all adj
2701: WHERE adj.customer_trx_id = app.customer_trx_id
2702: AND adj.upgrade_method = '11I'
2703: AND adj.status = 'A'
2704: AND adj.postable = 'Y');

Line 3130: FROM ar_adjustments_all adj

3126: AND evt.event_id = app.event_id
3127: AND app.status = 'APP'
3128: AND app.upgrade_method IS NULL
3129: AND EXISTS (SELECT '1'
3130: FROM ar_adjustments_all adj
3131: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3132: AND adj.upgrade_method = '11IMFAR'
3133: AND adj.status = 'A'
3134: AND adj.postable = 'Y')

Line 3146: FROM ar_adjustments_all adj

3142: AND evt.event_id = app.event_id
3143: AND app.status = 'APP'
3144: AND app.upgrade_method IS NULL
3145: AND EXISTS (SELECT '1'
3146: FROM ar_adjustments_all adj
3147: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3148: AND adj.upgrade_method = '11I'
3149: AND adj.status = 'A'
3150: AND adj.postable = 'Y')

Line 3179: FROM ar_adjustments_all adj

3175: AND app.status = 'APP'
3176: AND app.upgrade_method IS NULL
3177: -- AND app.cash_receipt_id = cr.cash_receipt_id(+)
3178: AND EXISTS (SELECT '1'
3179: FROM ar_adjustments_all adj
3180: WHERE adj.customer_trx_id = app.applied_customer_trx_id
3181: AND adj.upgrade_method = '11I'
3182: AND adj.status = 'A'
3183: AND adj.postable = 'Y'));