DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1161: ar_payment_schedules_all psa

1157: lines.INTERFACE_LINE_ATTRIBUTE5,
1158: lines.INTERFACE_LINE_ATTRIBUTE6
1159: from RA_CUSTOMER_TRX trx,
1160: RA_CUSTOMER_TRX_LINES lines,
1161: ar_payment_schedules_all psa
1162: where
1163: trx.batch_id = P_BATCH_ID
1164: and trx.customer_trx_id = lines.customer_trx_id
1165: and trx.customer_trx_id = psa.customer_trx_id(+) -- outer join is for case when invoice is created incomplete