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_UPG_PSA_DIST_PKG dependencies on DUAL

Line 278: (SELECT 'D' AS flag FROM DUAL

274: b.adjustment_id adj_id,
275: b.customer_trx_id customer_trx_id,
276: b.type type
277: FROM
278: (SELECT 'D' AS flag FROM DUAL
279: UNION ALL
280: SELECT 'C' AS flag FROM DUAL) a,
281: ar_adjustments_all b) doub,
282: psa_mf_trx_dist_all psatd,

Line 280: SELECT 'C' AS flag FROM DUAL) a,

276: b.type type
277: FROM
278: (SELECT 'D' AS flag FROM DUAL
279: UNION ALL
280: SELECT 'C' AS flag FROM DUAL) a,
281: ar_adjustments_all b) doub,
282: psa_mf_trx_dist_all psatd,
283: ra_customer_trx_all trx,
284: ra_cust_trx_line_gl_dist_all ctlgd

Line 515: (SELECT 'CASH' side FROM DUAL UNION

511: , DECODE(double.side,'CASH','N','Y') -- REF_MF_DIST_FLAG
512: , ard.REF_DIST_CCID
513: FROM ar_receivable_applications_all app,
514: ar_distributions_all ard,
515: (SELECT 'CASH' side FROM DUAL UNION
516: SELECT 'APP' side FROM DUAL ) double,
517: ar_cash_receipt_history_all crh
518: WHERE app.rowid >= l_start_rowid
519: AND app.rowid <= l_end_rowid

Line 516: SELECT 'APP' side FROM DUAL ) double,

512: , ard.REF_DIST_CCID
513: FROM ar_receivable_applications_all app,
514: ar_distributions_all ard,
515: (SELECT 'CASH' side FROM DUAL UNION
516: SELECT 'APP' side FROM DUAL ) double,
517: ar_cash_receipt_history_all crh
518: WHERE app.rowid >= l_start_rowid
519: AND app.rowid <= l_end_rowid
520: AND app.receivable_application_id = ard.source_id

Line 946: (SELECT 'REC' source_type FROM DUAL UNION

942: ar_receivable_applications_all app,
943: psa_mf_rct_dist_all a,
944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,

Line 947: SELECT 'EDISC' source_type FROM DUAL UNION

943: psa_mf_rct_dist_all a,
944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,

Line 948: SELECT 'UNEDISC' source_type FROM DUAL ) b,

944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,
952: ar_cash_receipt_history_all crh

Line 949: (SELECT 'D' side FROM DUAL UNION

945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,
952: ar_cash_receipt_history_all crh
953: WHERE app.rowid >= l_start_rowid

Line 950: SELECT 'C' side FROM DUAL ) doub,

946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
950: SELECT 'C' side FROM DUAL ) doub,
951: ra_customer_trx_all trx,
952: ar_cash_receipt_history_all crh
953: WHERE app.rowid >= l_start_rowid
954: AND app.rowid <= l_end_rowid

Line 1189: (SELECT 'D' side FROM DUAL UNION ALL

1185: psa_mf_misc_dist_all psamcd,
1186: ar_cash_receipts_all cr,
1187: ar_cash_receipt_history_all crh,
1188: ar_distributions_all crhard,
1189: (SELECT 'D' side FROM DUAL UNION ALL
1190: SELECT 'C' side FROM DUAL) doub
1191: WHERE mcd.rowid >= l_start_rowid
1192: AND mcd.rowid <= l_end_rowid
1193: AND mcd.misc_cash_distribution_id = psamcd.misc_cash_distribution_id

Line 1190: SELECT 'C' side FROM DUAL) doub

1186: ar_cash_receipts_all cr,
1187: ar_cash_receipt_history_all crh,
1188: ar_distributions_all crhard,
1189: (SELECT 'D' side FROM DUAL UNION ALL
1190: SELECT 'C' side FROM DUAL) doub
1191: WHERE mcd.rowid >= l_start_rowid
1192: AND mcd.rowid <= l_end_rowid
1193: AND mcd.misc_cash_distribution_id = psamcd.misc_cash_distribution_id
1194: AND mcd.cash_receipt_id = cr.cash_receipt_id