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 683: FROM ra_customer_trx_lines ctl,

679: --{ For CM APP on legacy from 11i
680: (SELECT tt.type type,
681: ctl.customer_trx_line_id customer_trx_line_id,
682: ctl.line_type line_type
683: FROM ra_customer_trx_lines ctl,
684: ra_customer_trx trx,
685: ra_cust_trx_types tt
686: WHERE ctl.customer_trx_id = trx.customer_trx_id
687: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 684: ra_customer_trx trx,

680: (SELECT tt.type type,
681: ctl.customer_trx_line_id customer_trx_line_id,
682: ctl.line_type line_type
683: FROM ra_customer_trx_lines ctl,
684: ra_customer_trx trx,
685: ra_cust_trx_types tt
686: WHERE ctl.customer_trx_id = trx.customer_trx_id
687: AND trx.cust_trx_type_id = tt.cust_trx_type_id
688: AND tt.org_id = trx.org_id) line_trx_type

Line 751: FROM ra_customer_trx_lines ctl,

747: -- For CM APP on legacy from 11i
748: (SELECT tt.type type,
749: ctl.customer_trx_line_id customer_trx_line_id,
750: ctl.line_type line_type
751: FROM ra_customer_trx_lines ctl,
752: ra_customer_trx trx,
753: ra_cust_trx_types tt
754: WHERE ctl.customer_trx_id = trx.customer_trx_id
755: AND trx.cust_trx_type_id = tt.cust_trx_type_id

Line 752: ra_customer_trx trx,

748: (SELECT tt.type type,
749: ctl.customer_trx_line_id customer_trx_line_id,
750: ctl.line_type line_type
751: FROM ra_customer_trx_lines ctl,
752: ra_customer_trx trx,
753: ra_cust_trx_types tt
754: WHERE ctl.customer_trx_id = trx.customer_trx_id
755: AND trx.cust_trx_type_id = tt.cust_trx_type_id
756: AND tt.org_id = trx.org_id) line_trx_type

Line 777: ra_customer_trx trx,

773: app.applied_customer_trx_id trx_id,
774: cm.upgrade_method cm_upgrade_method,
775: app.customer_trx_id cm_id
776: FROM ar_receivable_applications app,
777: ra_customer_trx trx,
778: ra_customer_trx cm
779: WHERE app.receivable_application_id = p_app_id
780: AND app.applied_customer_trx_id = trx.customer_trx_id
781: AND app.customer_trx_id = cm.customer_trx_id(+);

Line 778: ra_customer_trx cm

774: cm.upgrade_method cm_upgrade_method,
775: app.customer_trx_id cm_id
776: FROM ar_receivable_applications app,
777: ra_customer_trx trx,
778: ra_customer_trx cm
779: WHERE app.receivable_application_id = p_app_id
780: AND app.applied_customer_trx_id = trx.customer_trx_id
781: AND app.customer_trx_id = cm.customer_trx_id(+);
782:

Line 784: l_trx_rec ra_customer_trx%ROWTYPE;

780: AND app.applied_customer_trx_id = trx.customer_trx_id
781: AND app.customer_trx_id = cm.customer_trx_id(+);
782:
783: l_record_mark verif_trx_mark%ROWTYPE;
784: l_trx_rec ra_customer_trx%ROWTYPE;
785: l_requery VARCHAR2(1) := 'N';
786: /*-------------------------------------------------------------------+
787: | Get exchange rate, third part details and amounts for transaction |
788: | to which application has been made. There is a bit of redundancy |

Line 819: ra_customer_trx ctinv,

815: ctcm.trx_date cm_trx_date,
816: ctcm.bill_to_customer_id cm_bill_to_customer_id,
817: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
818: from ar_receivable_applications app ,
819: ra_customer_trx ctinv,
820: ra_customer_trx ctcm
821: where app.receivable_application_id = g_ae_doc_rec.source_id_old
822: and app.status = 'APP'
823: and nvl(confirmed_flag,'Y') = 'Y'

Line 820: ra_customer_trx ctcm

816: ctcm.bill_to_customer_id cm_bill_to_customer_id,
817: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
818: from ar_receivable_applications app ,
819: ra_customer_trx ctinv,
820: ra_customer_trx ctcm
821: where app.receivable_application_id = g_ae_doc_rec.source_id_old
822: and app.status = 'APP'
823: and nvl(confirmed_flag,'Y') = 'Y'
824: and g_ae_doc_rec.source_table = 'RA'

Line 835: l_cust_inv_rec ra_customer_trx%ROWTYPE;

831: l_set_pairing_id BOOLEAN:= FALSE;
832: l_ae_line_tbl ae_line_tbl_type;
833: l_ae_ctr NUMBER;
834: l_ctr NUMBER;
835: l_cust_inv_rec ra_customer_trx%ROWTYPE;
836: l_cust_cm_rec ra_customer_trx%ROWTYPE;
837: l_applied_customer_trx_id NUMBER;
838: l_amount_applied NUMBER;
839: l_acctd_amount_applied_to NUMBER;

Line 836: l_cust_cm_rec ra_customer_trx%ROWTYPE;

832: l_ae_line_tbl ae_line_tbl_type;
833: l_ae_ctr NUMBER;
834: l_ctr NUMBER;
835: l_cust_inv_rec ra_customer_trx%ROWTYPE;
836: l_cust_cm_rec ra_customer_trx%ROWTYPE;
837: l_applied_customer_trx_id NUMBER;
838: l_amount_applied NUMBER;
839: l_acctd_amount_applied_to NUMBER;
840: --{3377004

Line 1106: UPDATE ra_customer_trx_lines

1102: --{3377004
1103: IF l_index <> 0 THEN
1104:
1105: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1106: UPDATE ra_customer_trx_lines
1107: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1108: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1109: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1110: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1115: UPDATE ra_customer_trx_lines_gt

1111: WHERE customer_trx_line_id = l_ctl_rem_amt.customer_trx_line_id(m);
1112:
1113: --BUG#4753570 make the amount on trx line and gloabl has to in sync
1114: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
1115: UPDATE ra_customer_trx_lines_gt
1116: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
1117: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
1118: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
1119: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1244: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

1240: PROCEDURE Get_Doc_Entitity_Data (
1241: p_level IN VARCHAR2 ,
1242: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1243: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1244: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1245: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1246: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1247: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1248: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,

Line 1245: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

1241: p_level IN VARCHAR2 ,
1242: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1243: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1244: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1245: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1246: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
1247: p_miscel_rec OUT NOCOPY g_ae_miscel_rec_type ,
1248: p_vat_rec OUT NOCOPY ar_vat_tax%ROWTYPE ,
1249: p_curr_rec OUT NOCOPY ae_curr_rec_type ,

Line 1274: ra.customer_trx_id ,

1270: IF p_level = 'RA' then
1271:
1272: select ra.receivable_application_id ,
1273: ra.applied_customer_trx_id ,
1274: ra.customer_trx_id ,
1275: ra.applied_payment_schedule_id ,
1276: ra.code_combination_id ,
1277: ra.amount_applied ,
1278: ra.amount_applied_from ,

Line 1419: ra_customer_trx ctinv ,

1415: l_cr_unapp_ccid
1416: from ar_receivable_applications ra ,
1417: ar_cash_receipts cr ,
1418: ar_receipt_method_accounts rma ,
1419: ra_customer_trx ctinv ,
1420: ra_customer_trx ctcm ,
1421: ra_cust_trx_line_gl_dist ctlgdcm
1422: where ra.receivable_application_id = g_ae_doc_rec.source_id
1423: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information

Line 1420: ra_customer_trx ctcm ,

1416: from ar_receivable_applications ra ,
1417: ar_cash_receipts cr ,
1418: ar_receipt_method_accounts rma ,
1419: ra_customer_trx ctinv ,
1420: ra_customer_trx ctcm ,
1421: ra_cust_trx_line_gl_dist ctlgdcm
1422: where ra.receivable_application_id = g_ae_doc_rec.source_id
1423: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information
1424: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt

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

1423: and ra.cash_receipt_id = cr.cash_receipt_id (+) --CR UNID, ACC, UNAPP exchange rate Information
1424: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt
1425: and cr.receipt_method_id = rma.receipt_method_id (+)
1426: and ra.applied_customer_trx_id = ctinv.customer_trx_id (+) --INV REC or On Account CM exchange rate Information
1427: and ra.customer_trx_id = ctcm.customer_trx_id (+) --CM REC exchange rate Information
1428: and ra.customer_trx_id = ctlgdcm.customer_trx_id (+) --CM REC account ccid
1429: and decode(ra.application_type,
1430: 'CASH', 'REC',
1431: 'CM' , ctlgdcm.account_class) = 'REC'

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

1424: and cr.remit_bank_acct_use_id = rma.remit_bank_acct_use_id (+) --UNAPP ccid for receipt
1425: and cr.receipt_method_id = rma.receipt_method_id (+)
1426: and ra.applied_customer_trx_id = ctinv.customer_trx_id (+) --INV REC or On Account CM exchange rate Information
1427: and ra.customer_trx_id = ctcm.customer_trx_id (+) --CM REC exchange rate Information
1428: and ra.customer_trx_id = ctlgdcm.customer_trx_id (+) --CM REC account ccid
1429: and decode(ra.application_type,
1430: 'CASH', 'REC',
1431: 'CM' , ctlgdcm.account_class) = 'REC'
1432: and decode(ra.application_type,

Line 1491: from ra_customer_trx

1487: /* 4922353 - always get LE regardless of
1488: response from is_le_subscriber */
1489: select legal_entity_id
1490: into l_le_id
1491: from ra_customer_trx
1492: where customer_trx_id = p_app_rec.applied_customer_trx_id;
1493:
1494: /* 4594101 - Check if legal entities are in use and, if so,
1495: include the new child/detail table in the join */

Line 1830: l_cust_inv_rec ra_customer_trx%ROWTYPE ;

1826:
1827: l_miscel_rec g_ae_miscel_rec_type ;
1828: l_app_rec ar_receivable_applications%ROWTYPE ;
1829: l_cr_rec ar_cash_receipts%ROWTYPE ;
1830: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1831: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1832: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1833: l_vat_rec ar_vat_tax%ROWTYPE ;
1834: l_curr_rec ae_curr_rec_type ;

Line 1831: l_cust_cm_rec ra_customer_trx%ROWTYPE ;

1827: l_miscel_rec g_ae_miscel_rec_type ;
1828: l_app_rec ar_receivable_applications%ROWTYPE ;
1829: l_cr_rec ar_cash_receipts%ROWTYPE ;
1830: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1831: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1832: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1833: l_vat_rec ar_vat_tax%ROWTYPE ;
1834: l_curr_rec ae_curr_rec_type ;
1835: l_rule_rec ae_rule_rec_type ;

Line 1950: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

1946: * =================================================================================*/
1947: PROCEDURE Create_Ae_Lines_RA(
1948: p_app_rec IN ar_receivable_applications%ROWTYPE ,
1949: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
1950: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1951: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
1952: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
1953: p_miscel_rec IN g_ae_miscel_rec_type ,
1954: p_rule_rec IN ae_rule_rec_type ,

Line 1951: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,

1947: PROCEDURE Create_Ae_Lines_RA(
1948: p_app_rec IN ar_receivable_applications%ROWTYPE ,
1949: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
1950: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1951: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
1952: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
1953: p_miscel_rec IN g_ae_miscel_rec_type ,
1954: p_rule_rec IN ae_rule_rec_type ,
1955: --{HYUDETUPT

Line 1969: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;

1965: l_ae_ctr BINARY_INTEGER := 0;
1966: l_ctr BINARY_INTEGER;
1967: --{BUG#2927254
1968: l_app_rec ar_receivable_applications%ROWTYPE;
1969: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;
1970: l_i BINARY_INTEGER;
1971: l_j BINARY_INTEGER;
1972: l_amount_applied NUMBER;
1973: l_acctd_amount_applied NUMBER;