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.ARP_RECEIPTS_MAIN dependencies on RA_CUSTOMER_TRX

Line 55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

51: PROCEDURE Get_Doc_Entitity_Data (
52: p_level IN VARCHAR2 ,
53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
54: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
58: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
59: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,

Line 56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

52: p_level IN VARCHAR2 ,
53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
54: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
58: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
59: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,
60: p_curr_rec OUT NOCOPY ae_curr_rec_type ,

Line 81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

77:
78: PROCEDURE Create_Ae_Lines_RA(
79: p_app_rec IN ar_receivable_applications%ROWTYPE ,
80: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
84: p_miscel_rec IN g_ae_miscel_rec_type ,
85: p_rule_rec IN ae_rule_rec_type ,

Line 82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,

78: PROCEDURE Create_Ae_Lines_RA(
79: p_app_rec IN ar_receivable_applications%ROWTYPE ,
80: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
84: p_miscel_rec IN g_ae_miscel_rec_type ,
85: p_rule_rec IN ae_rule_rec_type ,
86: --{

Line 698: FROM ra_customer_trx_lines ctl,

694: --{ For CM APP on legacy from 11i
695: (SELECT tt.type type,
696: ctl.customer_trx_line_id customer_trx_line_id,
697: ctl.line_type line_type
698: FROM ra_customer_trx_lines ctl,
699: ra_customer_trx trx,
700: ra_cust_trx_types tt
701: WHERE ctl.customer_trx_id = trx.customer_trx_id
702: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 699: ra_customer_trx trx,

695: (SELECT tt.type type,
696: ctl.customer_trx_line_id customer_trx_line_id,
697: ctl.line_type line_type
698: FROM ra_customer_trx_lines ctl,
699: ra_customer_trx trx,
700: ra_cust_trx_types tt
701: WHERE ctl.customer_trx_id = trx.customer_trx_id
702: AND trx.cust_trx_type_id = tt.cust_trx_type_id
703: AND tt.org_id = trx.org_id) line_trx_type

Line 770: FROM ra_customer_trx_lines ctl,

766: -- For CM APP on legacy from 11i
767: (SELECT tt.type type,
768: ctl.customer_trx_line_id customer_trx_line_id,
769: ctl.line_type line_type
770: FROM ra_customer_trx_lines ctl,
771: ra_customer_trx trx,
772: ra_cust_trx_types tt
773: WHERE ctl.customer_trx_id = trx.customer_trx_id
774: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 771: ra_customer_trx trx,

767: (SELECT tt.type type,
768: ctl.customer_trx_line_id customer_trx_line_id,
769: ctl.line_type line_type
770: FROM ra_customer_trx_lines ctl,
771: ra_customer_trx trx,
772: ra_cust_trx_types tt
773: WHERE ctl.customer_trx_id = trx.customer_trx_id
774: AND trx.cust_trx_type_id = tt.cust_trx_type_id
775: AND tt.org_id = trx.org_id) line_trx_type

Line 797: ra_customer_trx trx,

793: cm.upgrade_method cm_upgrade_method,
794: app.customer_trx_id cm_id,
795: app.upgrade_method app_upgrade_method
796: FROM ar_receivable_applications app,
797: ra_customer_trx trx,
798: ra_customer_trx cm
799: WHERE app.receivable_application_id = p_app_id
800: AND app.applied_customer_trx_id = trx.customer_trx_id
801: AND app.customer_trx_id = cm.customer_trx_id(+);

Line 798: ra_customer_trx cm

794: app.customer_trx_id cm_id,
795: app.upgrade_method app_upgrade_method
796: FROM ar_receivable_applications app,
797: ra_customer_trx trx,
798: ra_customer_trx cm
799: WHERE app.receivable_application_id = p_app_id
800: AND app.applied_customer_trx_id = trx.customer_trx_id
801: AND app.customer_trx_id = cm.customer_trx_id(+);
802:

Line 804: l_trx_rec ra_customer_trx%ROWTYPE;

800: AND app.applied_customer_trx_id = trx.customer_trx_id
801: AND app.customer_trx_id = cm.customer_trx_id(+);
802:
803: l_record_mark verif_trx_mark%ROWTYPE;
804: l_trx_rec ra_customer_trx%ROWTYPE;
805: l_requery VARCHAR2(1) := 'N';
806: /*-------------------------------------------------------------------+
807: | Get exchange rate, third part details and amounts for transaction |
808: | to which application has been made. There is a bit of redundancy |

Line 839: ra_customer_trx ctinv,

835: ctcm.trx_date cm_trx_date,
836: ctcm.bill_to_customer_id cm_bill_to_customer_id,
837: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
838: from ar_receivable_applications app ,
839: ra_customer_trx ctinv,
840: ra_customer_trx ctcm
841: where app.receivable_application_id = g_ae_doc_rec.source_id_old
842: and app.status = 'APP'
843: and nvl(confirmed_flag,'Y') = 'Y'

Line 840: ra_customer_trx ctcm

836: ctcm.bill_to_customer_id cm_bill_to_customer_id,
837: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
838: from ar_receivable_applications app ,
839: ra_customer_trx ctinv,
840: ra_customer_trx ctcm
841: where app.receivable_application_id = g_ae_doc_rec.source_id_old
842: and app.status = 'APP'
843: and nvl(confirmed_flag,'Y') = 'Y'
844: and g_ae_doc_rec.source_table = 'RA'

Line 855: l_cust_inv_rec ra_customer_trx%ROWTYPE;

851: l_set_pairing_id BOOLEAN:= FALSE;
852: l_ae_line_tbl ae_line_tbl_type;
853: l_ae_ctr NUMBER;
854: l_ctr NUMBER;
855: l_cust_inv_rec ra_customer_trx%ROWTYPE;
856: l_cust_cm_rec ra_customer_trx%ROWTYPE;
857: l_applied_customer_trx_id NUMBER;
858: l_amount_applied NUMBER;
859: l_acctd_amount_applied_to NUMBER;

Line 856: l_cust_cm_rec ra_customer_trx%ROWTYPE;

852: l_ae_line_tbl ae_line_tbl_type;
853: l_ae_ctr NUMBER;
854: l_ctr NUMBER;
855: l_cust_inv_rec ra_customer_trx%ROWTYPE;
856: l_cust_cm_rec ra_customer_trx%ROWTYPE;
857: l_applied_customer_trx_id NUMBER;
858: l_amount_applied NUMBER;
859: l_acctd_amount_applied_to NUMBER;
860: --{3377004

Line 864: l_trx_upg_method ra_customer_trx.upgrade_method%type;

860: --{3377004
861: l_ctl_rem_amt ctl_rem_amt_type;
862: l_index NUMBER := 0;
863: l_app_upg_method ar_receivable_applications.upgrade_method%type;
864: l_trx_upg_method ra_customer_trx.upgrade_method%type;
865:
866: --}
867: BEGIN
868: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()+');

Line 1149: UPDATE ra_customer_trx_lines

1145: --{3377004
1146: IF l_index <> 0 THEN
1147:
1148: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1149: UPDATE ra_customer_trx_lines
1150: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1151: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1152: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1153: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1158: UPDATE ra_customer_trx_lines_gt

1154: WHERE customer_trx_line_id = l_ctl_rem_amt.customer_trx_line_id(m);
1155:
1156: --BUG#4753570 make the amount on trx line and gloabl has to in sync
1157: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1158: UPDATE ra_customer_trx_lines_gt
1159: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1160: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1161: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1162: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

1283: PROCEDURE Get_Doc_Entitity_Data (
1284: p_level IN VARCHAR2 ,
1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1286: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1290: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1291: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,

Line 1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

1284: p_level IN VARCHAR2 ,
1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1286: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1290: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1291: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,
1292: p_curr_rec OUT NOCOPY ae_curr_rec_type ,

Line 1317: ra.customer_trx_id ,

1313: IF p_level = 'RA' then
1314:
1315: select ra.receivable_application_id ,
1316: ra.applied_customer_trx_id ,
1317: ra.customer_trx_id ,
1318: ra.applied_payment_schedule_id ,
1319: ra.code_combination_id ,
1320: ra.amount_applied ,
1321: ra.amount_applied_from ,

Line 1464: ra_customer_trx ctinv ,

1460: l_cr_unapp_ccid
1461: from ar_receivable_applications ra ,
1462: ar_cash_receipts cr ,
1463: ar_receipt_method_accounts rma ,
1464: ra_customer_trx ctinv ,
1465: ra_customer_trx ctcm ,
1466: ra_cust_trx_line_gl_dist ctlgdcm
1467: where ra.receivable_application_id = g_ae_doc_rec.source_id
1468: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information

Line 1465: ra_customer_trx ctcm ,

1461: from ar_receivable_applications ra ,
1462: ar_cash_receipts cr ,
1463: ar_receipt_method_accounts rma ,
1464: ra_customer_trx ctinv ,
1465: ra_customer_trx ctcm ,
1466: ra_cust_trx_line_gl_dist ctlgdcm
1467: where ra.receivable_application_id = g_ae_doc_rec.source_id
1468: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information
1469: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt

Line 1472: and ra.customer_trx_id = ctcm.customer_trx_id (+) --CM REC exchange rate Information

1468: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information
1469: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt
1470: and cr.receipt_method_id = rma.receipt_method_id (+)
1471: and ra.applied_customer_trx_id = ctinv.customer_trx_id (+) --INV REC or On Account CM exchange rate Information
1472: and ra.customer_trx_id = ctcm.customer_trx_id (+) --CM REC exchange rate Information
1473: and ra.customer_trx_id = ctlgdcm.customer_trx_id (+) --CM REC account ccid
1474: and decode(ra.application_type,
1475: 'CASH', 'REC',
1476: 'CM' , ctlgdcm.account_class) = 'REC'

Line 1473: and ra.customer_trx_id = ctlgdcm.customer_trx_id (+) --CM REC account ccid

1469: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt
1470: and cr.receipt_method_id = rma.receipt_method_id (+)
1471: and ra.applied_customer_trx_id = ctinv.customer_trx_id (+) --INV REC or On Account CM exchange rate Information
1472: and ra.customer_trx_id = ctcm.customer_trx_id (+) --CM REC exchange rate Information
1473: and ra.customer_trx_id = ctlgdcm.customer_trx_id (+) --CM REC account ccid
1474: and decode(ra.application_type,
1475: 'CASH', 'REC',
1476: 'CM' , ctlgdcm.account_class) = 'REC'
1477: and decode(ra.application_type,

Line 1564: from ra_customer_trx

1560: /* 4922353 - always get LE regardless of
1561: response from is_le_subscriber */
1562: select legal_entity_id
1563: into l_le_id
1564: from ra_customer_trx
1565: where customer_trx_id = p_app_rec.applied_customer_trx_id;
1566:
1567: /* 4594101 - Check if legal entities are in use and, if so,
1568: include the new child/detail table in the join */

Line 1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;

1899:
1900: l_miscel_rec g_ae_miscel_rec_type ;
1901: l_app_rec ar_receivable_applications%ROWTYPE ;
1902: l_cr_rec ar_cash_receipts%ROWTYPE ;
1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1906: l_vat_rec ar_vat_tax%ROWTYPE ;
1907: l_curr_rec ae_curr_rec_type ;

Line 1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;

1900: l_miscel_rec g_ae_miscel_rec_type ;
1901: l_app_rec ar_receivable_applications%ROWTYPE ;
1902: l_cr_rec ar_cash_receipts%ROWTYPE ;
1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1906: l_vat_rec ar_vat_tax%ROWTYPE ;
1907: l_curr_rec ae_curr_rec_type ;
1908: l_rule_rec ae_rule_rec_type ;

Line 1909: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;

1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1906: l_vat_rec ar_vat_tax%ROWTYPE ;
1907: l_curr_rec ae_curr_rec_type ;
1908: l_rule_rec ae_rule_rec_type ;
1909: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;
1910: BEGIN
1911:
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common()+');

Line 2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

2049: * =================================================================================*/
2050: PROCEDURE Create_Ae_Lines_RA(
2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,
2052: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
2056: p_miscel_rec IN g_ae_miscel_rec_type ,
2057: p_rule_rec IN ae_rule_rec_type ,

Line 2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,

2050: PROCEDURE Create_Ae_Lines_RA(
2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,
2052: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
2056: p_miscel_rec IN g_ae_miscel_rec_type ,
2057: p_rule_rec IN ae_rule_rec_type ,
2058: --{HYUDETUPT

Line 2072: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;

2068: l_ae_ctr BINARY_INTEGER := 0;
2069: l_ctr BINARY_INTEGER;
2070: --{BUG#2927254
2071: l_app_rec ar_receivable_applications%ROWTYPE;
2072: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;
2073: l_i BINARY_INTEGER;
2074: l_j BINARY_INTEGER;
2075: l_amount_applied NUMBER;
2076: l_acctd_amount_applied NUMBER;