DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on AR_CONS_INV

Line 1327: AR_CONS_INV CONS_INV';

1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1324: fa_rx_util_pkg.From_Clause := '
1325: AR_PAYMENT_SCHEDULES PS,'||
1326: fa_rx_util_pkg.From_Clause || ',
1327: AR_CONS_INV CONS_INV';
1328:
1329: --
1330: -- Add to the WHERE clause specific to this report
1331: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');

Line 1874: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV

1870: return VARCHAR2
1871: is
1872: CURSOR CONS_BILL(CTID IN NUMBER) IS
1873: SELECT CONS_INV.CONS_BILLING_NUMBER
1874: FROM AR_PAYMENT_SCHEDULES PS, AR_CONS_INV CONS_INV
1875: WHERE PS.CONS_INV_ID = CONS_INV.CONS_INV_ID
1876: AND PS.STATUS = 'OP'
1877: AND PS.CUSTOMER_TRX_ID = CTID;
1878: