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.PSA_XFR_TO_GL_PKG dependencies on PSA_LOOKUP_CODES

Line 464: psa_lookup_codes l1,

460: 'MISC_' || ard.source_type ref29,
461: 'PSA_MF_MISC_DIST_ALL' ref30
462: FROM
463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,
468: ar_cash_receipt_history crh,

Line 582: psa_lookup_codes l1,

578: 'TRADE_') ref29,
579: 'PSA_MF_MISC_DIST_ALL' ref30
580: FROM
581: psa_mf_misc_dist_all mfd,
582: psa_lookup_codes l1,
583: ar_misc_cash_distributions mcd,
584: ar_cash_receipts cr,
585: ar_cash_receipt_history crh,
586: ar_cash_receipt_history crhold

Line 1130: psa_lookup_codes l1,

1126: ra_customer_trx ct,
1127: ra_cust_trx_line_gl_dist ctlgd,
1128: ra_cust_trx_types ctt,
1129: hz_cust_accounts hca,
1130: psa_lookup_codes l1,
1131: psa_mf_trx_dist_all psa_trx_dist
1132: WHERE
1133: ctlgd.customer_trx_id = p_customer_trx_id
1134: AND ctlgd.customer_trx_id = ct.customer_trx_id

Line 1612: psa_lookup_codes l1

1608: ra_cust_trx_types ctt,
1609: ar_cash_receipt_history crh,
1610: psa_mf_rct_dist_all psa_rct_dist,
1611: psa_mf_trx_dist_all psa_trx_dist,
1612: psa_lookup_codes l1
1613: WHERE
1614: psa_rct_dist.receivable_application_id = p_receivable_application_id
1615: AND psa_rct_dist.ue_discount_ccid IS NULL
1616: AND psa_rct_dist.receivable_application_id = ra.receivable_application_id

Line 1703: psa_lookup_codes l1

1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,
1701: psa_mf_rct_dist_all psa_rct_dist,
1702: psa_mf_trx_dist_all psa_trx_dist,
1703: psa_lookup_codes l1
1704: WHERE
1705: psa_rct_dist.receivable_application_id = p_receivable_application_id
1706: AND psa_rct_dist.receivable_application_id = ra.receivable_application_id
1707: AND psa_trx_dist.cust_trx_line_gl_dist_id = psa_rct_dist.cust_trx_line_gl_dist_id

Line 1822: psa_lookup_codes l1

1818: ar_cash_receipt_history crhnew,
1819: ar_cash_receipt_history crhold,
1820: psa_mf_rct_dist_all psa_rct_dist,
1821: psa_mf_trx_dist_all psa_trx_dist,
1822: psa_lookup_codes l1
1823: WHERE
1824: psa_rct_dist.receivable_application_id = p_receivable_application_id
1825: AND psa_rct_dist.ue_discount_ccid IS NOT NULL
1826: AND psa_rct_dist.attribute1 = 'CLEARED'

Line 2561: psa_lookup_codes l

2557: psa_mf_trx_dist_all psa_trx_dist,
2558: ra_customer_trx ct,
2559: ra_cust_trx_line_gl_dist ctlgd,
2560: ra_cust_trx_types ctt,
2561: psa_lookup_codes l
2562: WHERE psa_adj_dist.adjustment_id = adj.adjustment_id
2563: AND adj.adjustment_id = p_adjustment_id
2564: AND psa_trx_dist.cust_trx_line_gl_dist_id = psa_adj_dist.cust_trx_line_gl_dist_id
2565: AND adj.customer_trx_id = ct.customer_trx_id

Line 3880: psa_lookup_codes l1

3876: ar_cash_receipt_history crh,
3877: psa_mf_rct_dist_all psa_rct_dist,
3878: psa_mf_trx_dist_all psa_trx_dist,
3879: ra_cust_trx_line_gl_dist ar_trx_dist,
3880: psa_lookup_codes l1
3881: WHERE
3882: psa_rct_dist.receivable_application_id = p_receivable_application_id
3883: AND psa_rct_dist.ue_discount_ccid IS NULL
3884: AND psa_rct_dist.receivable_application_id = ra.receivable_application_id

Line 4159: psa_lookup_codes l1,

4155: 'MISC_' || ard.source_type ref29,
4156: 'PSA_MF_MISC_DIST_ALL' ref30
4157: FROM
4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,
4161: ar_distributions_all ard,
4162: ar_cash_receipts_all cr,
4163: ar_cash_receipt_history_all crh