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.PA_PWP_INVOICE_REL dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 146: FROM ar_payment_schedules_all arp

142: (SELECT 1
143: FROM dual
144: WHERE EXISTS
145: (SELECT 1
146: FROM ar_payment_schedules_all arp
147: WHERE /*arp.status = 'OP' Bug 8284969 */
148: ARP.AMOUNT_DUE_REMAINING <> 0
149: AND Sign(ARP.AMOUNT_DUE_ORIGINAL) = Sign(ARP.AMOUNT_DUE_REMAINING )
150: AND rac.customer_trx_id = arp.customer_trx_id

Line 774: FROM AR_PAYMENT_SCHEDULES_ALL ARP

770: AND PDI.DRAFT_INVOICE_NUM = CRDL.DRAFT_INVOICE_NUM
771: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')-- INVOICE NOT YET TRANSFERED TO AR
772: OR EXISTS
773: (SELECT 1
774: FROM AR_PAYMENT_SCHEDULES_ALL ARP
775: ,RA_CUSTOMER_TRX RAC
776: WHERE /* ARP.STATUS = 'OP' Bug 8284969 */
777: ARP.AMOUNT_DUE_REMAINING <> 0
778: AND Sign(ARP.AMOUNT_DUE_ORIGINAL) = Sign(ARP.AMOUNT_DUE_REMAINING )

Line 805: FROM AR_PAYMENT_SCHEDULES_ALL ARP

801: AND PWP.AP_INVOICE_ID = P_INVOICE_ID
802: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')
803: OR EXISTS
804: (SELECT 1
805: FROM AR_PAYMENT_SCHEDULES_ALL ARP
806: , RA_CUSTOMER_TRX RAC
807: WHERE /*ARP.STATUS = 'OP' Bug 8284969 */
808: ARP.AMOUNT_DUE_REMAINING <> 0
809: AND Sign(ARP.AMOUNT_DUE_ORIGINAL) = Sign(ARP.AMOUNT_DUE_REMAINING )