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 155: FROM ar_payment_schedules_all arp

151: (SELECT 1
152: FROM dual
153: WHERE EXISTS
154: (SELECT 1
155: FROM ar_payment_schedules_all arp
156: WHERE arp.status = 'OP'
157: AND rac.customer_trx_id = arp.customer_trx_id
158: )
159: )

Line 770: FROM AR_PAYMENT_SCHEDULES_ALL ARP

766: AND PDI.DRAFT_INVOICE_NUM = CRDL.DRAFT_INVOICE_NUM
767: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')-- INVOICE NOT YET TRANSFERED TO AR
768: OR EXISTS
769: (SELECT 1
770: FROM AR_PAYMENT_SCHEDULES_ALL ARP
771: ,RA_CUSTOMER_TRX RAC
772: WHERE ARP.STATUS = 'OP'
773: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID
774: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1

Line 799: FROM AR_PAYMENT_SCHEDULES_ALL ARP

795: AND PWP.AP_INVOICE_ID = P_INVOICE_ID
796: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')
797: OR EXISTS
798: (SELECT 1
799: FROM AR_PAYMENT_SCHEDULES_ALL ARP
800: , RA_CUSTOMER_TRX RAC
801: WHERE ARP.STATUS = 'OP'
802: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID
803: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1