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.ZX_AP_EXTRACT_PKG dependencies on AP_HOLDS

Line 4157: FROM AP_HOLDS AH

4153: 'UNAPPROVED','Y',
4154: 'NEEDS REAPPROVAL', DECODE((SELECT COUNT(*)
4155: FROM DUAL
4156: WHERE NOT EXISTS (SELECT 1
4157: FROM AP_HOLDS AH
4158: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
4159: OR EXISTS (SELECT 1
4160: FROM AP_HOLDS AH1, AP_HOLD_CODES AHC
4161: WHERE AH1.RELEASE_LOOKUP_CODE IS NULL

Line 4160: FROM AP_HOLDS AH1, AP_HOLD_CODES AHC

4156: WHERE NOT EXISTS (SELECT 1
4157: FROM AP_HOLDS AH
4158: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
4159: OR EXISTS (SELECT 1
4160: FROM AP_HOLDS AH1, AP_HOLD_CODES AHC
4161: WHERE AH1.RELEASE_LOOKUP_CODE IS NULL
4162: AND AI.INVOICE_ID = AH1.INVOICE_ID
4163: AND AH1.HOLD_LOOKUP_CODE = AHC.HOLD_LOOKUP_CODE
4164: AND NVL(AHC.POSTABLE_FLAG,'N') = 'N')