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 AR_CASH_RECEIPT_HISTORY

Line 418: SELECT cash_receipt_history_id FROM ar_cash_receipt_history

414: IS
415:
416: CURSOR c_crh_post
417: IS
418: SELECT cash_receipt_history_id FROM ar_cash_receipt_history
419: WHERE posting_control_id = l_pst_ctrl_id
420: AND cash_receipt_history_id NOT IN
421: (SELECT cash_receipt_history_id FROM psa_misc_posting);
422:

Line 425: SELECT cr.cash_receipt_id FROM ar_cash_receipts cr, ar_cash_receipt_history crh

421: (SELECT cash_receipt_history_id FROM psa_misc_posting);
422:
423: CURSOR c_create_dist
424: IS
425: SELECT cr.cash_receipt_id FROM ar_cash_receipts cr, ar_cash_receipt_history crh
426: WHERE cr.cash_receipt_id = crh.cash_receipt_id
427: AND crh.posting_control_id = l_pst_ctrl_id;
428:
429:

Line 468: ar_cash_receipt_history crh,

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,
469: ar_distributions ard2
470: WHERE
471: l1.lookup_type = 'PSA_CARTESIAN_JOIN'
472: AND l1.lookup_code IN ('1','2')

Line 521: 'AR_CASH_RECEIPT_HISTORY' ref30

517: 'TRADE') ref28,
518: DECODE( cr.type,
519: 'MISC', 'MISC_',
520: 'TRADE_') || ard.source_type ref29,
521: 'AR_CASH_RECEIPT_HISTORY' ref30
522: FROM
523: ar_cash_receipt_history crh,
524: psa_receivables_trx_all psa,
525: ar_distributions ard,

Line 523: ar_cash_receipt_history crh,

519: 'MISC', 'MISC_',
520: 'TRADE_') || ard.source_type ref29,
521: 'AR_CASH_RECEIPT_HISTORY' ref30
522: FROM
523: ar_cash_receipt_history crh,
524: psa_receivables_trx_all psa,
525: ar_distributions ard,
526: ar_cash_receipts cr
527: WHERE

Line 585: ar_cash_receipt_history crh,

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
587: WHERE
588: mfd.reference1 = 'CLEARED'
589: AND l1.lookup_type = 'PSA_CARTESIAN_JOIN'

Line 586: ar_cash_receipt_history crhold

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
587: WHERE
588: mfd.reference1 = 'CLEARED'
589: AND l1.lookup_type = 'PSA_CARTESIAN_JOIN'
590: AND l1.lookup_code IN (1,2)

Line 943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE

939: END LOOP;
940:
941: /*
942: ## Insert a record into psa_misc_posting to keep track of
943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
944: */
945:
946: -- ========================= FND LOG ===========================
947: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1069: ar_cash_receipt_history crh,

1065: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1066: UNION
1067: SELECT ra.applied_customer_trx_id
1068: FROM ar_receivable_applications ra,
1069: ar_cash_receipt_history crh,
1070: ar_cash_receipt_history crho
1071: WHERE crh.posting_control_id = l_pst_ctrl_id
1072: AND crh.cash_receipt_history_id = crho.reversal_cash_receipt_hist_id
1073: AND crh.cash_receipt_id = ra.cash_receipt_id

Line 1070: ar_cash_receipt_history crho

1066: UNION
1067: SELECT ra.applied_customer_trx_id
1068: FROM ar_receivable_applications ra,
1069: ar_cash_receipt_history crh,
1070: ar_cash_receipt_history crho
1071: WHERE crh.posting_control_id = l_pst_ctrl_id
1072: AND crh.cash_receipt_history_id = crho.reversal_cash_receipt_hist_id
1073: AND crh.cash_receipt_id = ra.cash_receipt_id
1074: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ra.receivable_application_id, 'RCT', l_sob_id),

Line 1438: FROM ar_cash_receipt_history h1,

1434:
1435: Cursor c_crh_posted
1436: IS
1437: SELECT h1.cash_receipt_history_id, h1.status
1438: FROM ar_cash_receipt_history h1,
1439: ar_cash_receipt_history h2
1440: WHERE h1.posting_control_id = l_pst_ctrl_id
1441: AND h1.cash_receipt_history_id = h2.reversal_cash_receipt_hist_id
1442: ORDER BY h1.cash_receipt_history_id ;

Line 1439: ar_cash_receipt_history h2

1435: Cursor c_crh_posted
1436: IS
1437: SELECT h1.cash_receipt_history_id, h1.status
1438: FROM ar_cash_receipt_history h1,
1439: ar_cash_receipt_history h2
1440: WHERE h1.posting_control_id = l_pst_ctrl_id
1441: AND h1.cash_receipt_history_id = h2.reversal_cash_receipt_hist_id
1442: ORDER BY h1.cash_receipt_history_id ;
1443:

Line 1457: FROM ar_receivable_applications ra, ar_cash_receipt_history crh, ar_cash_receipt_history crho

1453: -- selects app_id if original cash receipt status had been reversed.
1454: CURSOR Cur_Clr_MFAR_rct_app_id
1455: IS
1456: SELECT distinct ra.receivable_application_id receivable_application_id
1457: FROM ar_receivable_applications ra, ar_cash_receipt_history crh, ar_cash_receipt_history crho
1458: WHERE crh.posting_control_id = l_pst_ctrl_id
1459: AND crh.cash_receipt_history_id = crho.reversal_cash_receipt_hist_id
1460: AND crh.cash_receipt_id = ra.cash_receipt_id
1461: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check

Line 1487: In AR_CASH_RECEIPT_HISTORY_ALL, account_code_combination_id stores remittance account if status = 'REMITTED'

1483: 2. MFAR Reversal of Core Receivable Account
1484: 3. MFAR Remittance Account
1485: 4. MFAR reversal of Core Remittance Account ( derived from Transaction Dist A/c)
1486:
1487: In AR_CASH_RECEIPT_HISTORY_ALL, account_code_combination_id stores remittance account if status = 'REMITTED'
1488: account_code_combination_id stores Cash account if status = 'CLEARED'
1489: For MFAR Entries, the description should be appropriately changed based on Remittance requirement.
1490: ###############################################################################
1491: */

Line 1609: ar_cash_receipt_history crh,

1605: AND rownum = 1) ard,
1606: ra_customer_trx ctcm,
1607: ra_customer_trx ctinv,
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

Line 1700: ar_cash_receipt_history crh,

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,
1702: psa_mf_trx_dist_all psa_trx_dist,
1703: psa_lookup_codes l1
1704: WHERE

Line 1818: ar_cash_receipt_history crhnew,

1814: AND source_id = p_receivable_application_id
1815: AND rownum = 1) ard,
1816: ra_customer_trx ctinv,
1817: ra_cust_trx_types ctt,
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

Line 1819: ar_cash_receipt_history crhold,

1815: AND rownum = 1) ard,
1816: ra_customer_trx ctinv,
1817: ra_cust_trx_types ctt,
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

Line 2090: (SELECT receivable_application_id FROM ar_receivable_applications ara, ar_cash_receipt_history crh

2086: UPDATE psa_mf_rct_dist_all pda
2087: SET pda.posting_control_id = l_pst_ctrl_id
2088: WHERE pda.attribute1 = 'CLEARED'
2089: AND pda.receivable_application_id IN
2090: (SELECT receivable_application_id FROM ar_receivable_applications ara, ar_cash_receipt_history crh
2091: WHERE ara.cash_receipt_id = crh.cash_receipt_id AND crh.status = 'CLEARED'
2092: AND crh.posting_control_id = l_pst_ctrl_id) ;
2093:
2094: -- ========================= FND LOG ===========================

Line 3737: CURSOR c_crh_parent IS SELECT status FROM ar_cash_receipt_history WHERE

3733: p_amount IN NUMBER,
3734: p_crh_status IN VARCHAR2,
3735: p_crh_first_record_flag IN VARCHAR2,
3736: p_rev_crh_id IN NUMBER) RETURN varchar2 IS
3737: CURSOR c_crh_parent IS SELECT status FROM ar_cash_receipt_history WHERE
3738: cash_receipt_history_id = p_rev_crh_id;
3739: l_status VARCHAR2(30);
3740: BEGIN
3741: IF p_amount < 0 THEN

Line 3876: ar_cash_receipt_history crh,

3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
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

Line 4117: SELECT cash_receipt_history_id FROM ar_cash_receipt_history_all

4113: IS
4114:
4115: CURSOR c_crh_post
4116: IS
4117: SELECT cash_receipt_history_id FROM ar_cash_receipt_history_all
4118: WHERE posting_control_id = l_pst_ctrl_id
4119: AND cash_receipt_history_id NOT IN
4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:

Line 4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh

4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:
4122: CURSOR c_create_dist
4123: IS
4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh
4125: WHERE cr.cash_receipt_id = crh.cash_receipt_id
4126: -- AND crh.status = 'CLEARED'
4127: AND fnd_date.date_to_canonical (crh.gl_date) BETWEEN fnd_date.date_to_canonical (TO_DATE (l_gl_start_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'))
4128: AND fnd_date.date_to_canonical (TO_DATE (l_post_through_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'));

Line 4163: ar_cash_receipt_history_all crh

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
4164: WHERE
4165: l1.lookup_type = 'PSA_CARTESIAN_JOIN'
4166: AND l1.lookup_code IN ('1','2')
4167: AND mfd.misc_cash_distribution_id = mcd.misc_cash_distribution_id

Line 4321: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE

4317: END LOOP;
4318:
4319: /*
4320: ## Insert a record into psa_misc_posting to keep track of
4321: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
4322: */
4323:
4324: FOR J IN c_crh_post
4325: LOOP