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.FV_RECEIVABLES_ACTIVITY_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 251: FROM RA_CUSTOMER_TRX_ALL rct,

247: aps.payment_schedule_id,
248: interface_header_attribute3 created_from,
249: hzp1.category_code customer_category_code
250: --fvis.status
251: FROM RA_CUSTOMER_TRX_ALL rct,
252: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
253: AR_PAYMENT_SCHEDULES_ALL aps,
254: --RA_CUSTOMERS rc, Bug#4476059 Quick Change
255: hz_cust_accounts hzca1,

Line 296: FROM RA_CUSTOMER_TRX_ALL rct2,

292: aps2.payment_schedule_id,
293: rct2.interface_header_attribute3 created_from,
294: hzp2.category_code customer_category_code
295: -- fvis.status
296: FROM RA_CUSTOMER_TRX_ALL rct2,
297: AR_PAYMENT_SCHEDULES_ALL aps2,
298: --RA_CUSTOMERS rc2 Bug#4476059 Quick Change
299: hz_cust_accounts hzca2,
300: hz_parties hzp2

Line 312: from RA_CUSTOMER_TRX_ALL rct3,

308: --added to main query for delinquent debt 180 days or less
309: --and aps2.customer_trx_id = fvis.customer_trx_id (+)
310: and rct2.related_customer_trx_id in
311: (Select rct3.customer_trx_id
312: from RA_CUSTOMER_TRX_ALL rct3,
313: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
314: --RA_CUSTOMERS rc3,-- Bug#4476059 Quick Change
315: hz_cust_accounts hzca3,
316: hz_parties hzp3,

Line 346: FROM ra_customer_trx_all rct , fv_invoice_statuses_all fvis

342: ---AND NVL(fvis.end_date, vg_end_date) ;
343:
344: CURSOR CUR_INV_STATUS( p_customer_trx_id NUMBER ) IS
345: SELECT status
346: FROM ra_customer_trx_all rct , fv_invoice_statuses_all fvis
347: WHERE rct.customer_trx_id = P_customer_trx_id
348: AND fvis.customer_trx_id = rct.customer_trx_id
349: AND vg_end_date BETWEEN NVL(fvis.start_date,vg_end_date)
350: AND NVL(fvis.end_date,vg_end_date);

Line 624: FROM ra_customer_trx_all rct

620: -- this is to pick on the status that falls within the
621: -- period for which the report is running for.
622: SELECT related_customer_trx_id
623: INTO l_customer_trx_id
624: FROM ra_customer_trx_all rct
625: WHERE rct.customer_trx_id = recs.customer_trx_id
626: AND rct.SET_OF_BOOKS_ID = vp_sob_id; -- Bug 4655467
627: -- AND rct.org_id = vp_org_id ; -- Bug 4655467
628: EXCEPTION

Line 1013: FROM RA_CUSTOMER_TRX_ALL rct,

1009: aps.class,
1010: aps.payment_schedule_id,
1011: rct.interface_header_attribute3 created_from,
1012: hzp1.category_code customer_category_code
1013: FROM RA_CUSTOMER_TRX_ALL rct,
1014: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
1015: AR_PAYMENT_SCHEDULES_ALL aps,
1016: --RA_CUSTOMERS rc, --Bug#4476059 Quick Change
1017: hz_cust_accounts hzca1,

Line 1053: from RA_CUSTOMER_TRX_ALL rct2,

1049: aps2.class,
1050: aps2.payment_schedule_id,
1051: rct2.interface_header_attribute3 created_from,
1052: hzp2.category_code customer_category_code
1053: from RA_CUSTOMER_TRX_ALL rct2,
1054: ar_payment_schedules_all aps2,
1055: --ra_customers rc2 --Bug#4476059 Quick Change
1056: hz_cust_accounts hzca2,
1057: hz_parties hzp2

Line 1068: from RA_CUSTOMER_TRX_ALL rct3,

1064: and rct2.related_customer_trx_id
1065:
1066: IN
1067: (Select rct3.customer_trx_id
1068: from RA_CUSTOMER_TRX_ALL rct3,
1069: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
1070: --RA_CUSTOMERS rc3, --Bug#4476059 Quick Change
1071: hz_cust_accounts hzca3,
1072: hz_parties hzp3,

Line 1117: ra_customer_trx_all rct,

1113: hzp1.category_code customer_category_code,
1114: ara.type,
1115: rctt.type trx_type
1116: FROM ar_adjustments_all ara,
1117: ra_customer_trx_all rct,
1118: --ra_customers rc, --Bug#4476059 Quick Change
1119: hz_cust_accounts hzca1,
1120: hz_parties hzp1,
1121: ra_cust_trx_types_all rctt,

Line 1152: ra_customer_trx_all rct

1148: ar_cash_receipts_all acr,
1149: --ra_customers rc, ----Bug#4476059 Quick Change
1150: hz_cust_accounts hzca1,
1151: hz_parties hzp1,
1152: ra_customer_trx_all rct
1153: where ara.cash_receipt_id = acr.cash_receipt_id
1154: and ara.status = 'APP'
1155: and ara.apply_date between vl_fy_begin_date and vg_end_date+1
1156: and rct.customer_trx_id = p_customer_trx_id

Line 1263: l_status ra_customer_trx_all.status_trx%type ;

1259: schedule_id ar_receivable_applications_all.applied_payment_schedule_id%type;
1260:
1261: dummy varchar2(2);
1262: fc_flag varchar2(2);
1263: l_status ra_customer_trx_all.status_trx%type ;
1264: IIC_Col_recs_Increment NUMBER;
1265:
1266: BEGIN
1267:

Line 1453: FROM ra_customer_trx_all

1449: (vp_WRITE_OFF_ACTIVITY_1,vP_WRITE_OFF_ACTIVITY_2,vp_WRITE_OFF_ACTIVITY_3)
1450: THEN
1451: SELECT status_trx
1452: INTO l_status
1453: FROM ra_customer_trx_all
1454: WHERE customer_trx_id = adj_recs.customer_trx_id;
1455:
1456: IF l_status IN ('OP', 'PEN') THEN
1457: amt_write_off_A := amt_write_off_A + adj_recs.amount;