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 RA_CUST_TRX_LINE_GL_DIST

Line 1048: FROM ra_cust_trx_line_gl_dist ctlgd

1044: IS
1045: -- Bug 3757993 (Tpradhan) .. Start
1046: -- Added UNION clauses to select transactions associated with receipts and adjustments
1047: SELECT ctlgd.customer_trx_id customer_trx_id
1048: FROM ra_cust_trx_line_gl_dist ctlgd
1049: WHERE ctlgd.posting_control_id = l_pst_ctrl_id
1050: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ctlgd.customer_trx_id, 'TRX', l_sob_id),
1051: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1052: UNION

Line 1123: 'RA_CUST_TRX_LINE_GL_DIST' ref30

1119: DECODE (ctt.type, 'CM', 'CM_',
1120: 'DM', 'DM_',
1121: 'CB', 'CB_', 'INV_') || ctlgd.account_class ref29,
1122: -- 'PSA_TRX_DIST' ref30
1123: 'RA_CUST_TRX_LINE_GL_DIST' ref30
1124: FROM
1125: ar_lookups l,
1126: ra_customer_trx ct,
1127: ra_cust_trx_line_gl_dist ctlgd,

Line 1127: ra_cust_trx_line_gl_dist ctlgd,

1123: 'RA_CUST_TRX_LINE_GL_DIST' ref30
1124: FROM
1125: ar_lookups l,
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

Line 1250: AND GI.reference30 = 'RA_CUST_TRX_LINE_GL_DIST'

1246: WHERE GI.user_je_source_name = 'Receivables'
1247: AND GI.set_of_books_id = l_sob_id
1248: AND GI.group_id = l_pst_ctrl_id
1249: AND GI.reference29 IN ('INV_REC', 'DM_REC')
1250: AND GI.reference30 = 'RA_CUST_TRX_LINE_GL_DIST'
1251: AND GI.reference22 = to_char(I.customer_trx_id);
1252:
1253: -- ========================= FND LOG ===========================
1254: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1358: (SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct

1354:
1355: UPDATE psa_mf_trx_dist_all ptda
1356: SET ptda.posting_control_id = l_pst_ctrl_id
1357: WHERE ptda.cust_trx_line_gl_dist_id IN
1358: (SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct
1359: WHERE rct.posting_control_id = l_pst_ctrl_id);
1360:
1361: IF (SQL%FOUND) THEN
1362: -- ========================= FND LOG ===========================

Line 1374: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct

1370:
1371: DELETE FROM psa_mf_trx_dist_all
1372: WHERE posting_control_id = l_pst_ctrl_id
1373: AND cust_trx_line_gl_dist_id NOT IN
1374: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct
1375: WHERE rct.posting_control_id = l_pst_ctrl_id);
1376:
1377: -- ========================= FND LOG ===========================
1378: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1598: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30

1594: 'CM', 'CM') ref28,
1595: DECODE(ra.application_type, 'CASH', DECODE (ra.amount_applied_from, NULL,'TRADE_' ||ard.source_type, 'CCURR_' ||ard.source_type),
1596: 'CM', 'CM_'||ard.source_type) ref29,
1597: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
1598: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
1599: FROM
1600: ar_receivable_applications ra,
1601: ar_cash_receipts cr,
1602: (SELECT * FROM ar_distributions

Line 1688: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30

1684: DECODE(ra.application_type, 'CASH', DECODE (ra.amount_applied_from, NULL,'TRADE_' ||ard.source_type, 'CCURR_' ||ard.source_type),
1685: 'CM', 'CMAPP_'||ard.source_type) ref29,
1686: -- 'PSA_RCT_DIST' ref30
1687: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
1688: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
1689: FROM
1690: ar_receivable_applications ra,
1691: (SELECT * FROM ar_distributions
1692: WHERE source_table = 'RA'

Line 1696: ra_cust_trx_line_gl_dist gld,

1692: WHERE source_table = 'RA'
1693: AND source_id = p_receivable_application_id
1694: AND rownum = 1) ard,
1695: ra_customer_trx ctcm,
1696: ra_cust_trx_line_gl_dist gld,
1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,

Line 1697: ra_cust_trx_line_gl_dist gld_inv,

1693: AND source_id = p_receivable_application_id
1694: AND rownum = 1) ard,
1695: ra_customer_trx ctcm,
1696: ra_cust_trx_line_gl_dist gld,
1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,
1701: psa_mf_rct_dist_all psa_rct_dist,

Line 2559: ra_cust_trx_line_gl_dist ctlgd,

2555: FROM ar_adjustments adj,
2556: psa_mf_adj_dist_all psa_adj_dist,
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

Line 3869: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30

3865: 'CM', 'CMAPP') ref28,
3866: DECODE(ra.application_type, 'CASH', DECODE (ra.amount_applied_from, NULL,'TRADE_' ||ar_trx_dist.account_class, 'CCURR_' ||ar_trx_dist.account_class),
3867: 'CM', 'CMAPP_'||ar_trx_dist.account_class) ref29,
3868: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
3869: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
3870: FROM
3871: ar_receivable_applications ra,
3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,

Line 3879: ra_cust_trx_line_gl_dist ar_trx_dist,

3875: ra_cust_trx_types ctt,
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