DBA Data[Home] [Help]

APPS.ARRX_RC dependencies on AR_RECEIVABLE_APPLICATIONS

Line 806: AR_RECEIVABLE_APPLICATIONS RA,

802:
803: IF NVL(var.ca_sob_type,'P') = 'P' THEN
804: fa_rx_util_pkg.From_Clause :=
805: fa_rx_util_pkg.From_Clause || ',
806: AR_RECEIVABLE_APPLICATIONS RA,
807: RA_CUSTOMER_TRX TRX,
808: RA_CUST_TRX_LINE_GL_DIST REC';
809: ELSE
810: fa_rx_util_pkg.From_Clause :=

Line 1000: ', AR_RECEIVABLE_APPLICATIONS RA,

996:
997: IF NVL(var.ca_sob_type,'P') = 'P' THEN
998: fa_rx_util_pkg.From_Clause :=
999: fa_rx_util_pkg.From_Clause ||
1000: ', AR_RECEIVABLE_APPLICATIONS RA,
1001: RA_CUSTOMER_TRX TRX,
1002: RA_CUST_TRX_LINE_GL_DIST REC,
1003: HZ_CUST_ACCOUNTS RAC ,
1004: AR_PAYMENT_SCHEDULES PS ,

Line 1380: from ar_receivable_applications

1376: decode(sum(decode(status,'UNAPP', amount_applied,0))
1377: , 0 , var.l_app , var.l_unapp),
1378: var.l_unid)
1379: into var.receipt_status
1380: from ar_receivable_applications
1381: where cash_receipt_id = var.cash_receipt_id;
1382: END IF;
1383: ELSE
1384: IF var.cr_status in ('REV', 'NSF', 'STOP') AND