DBA Data[Home] [Help]

APPS.ZX_AP_EXTRACT_PKG dependencies on AP_HOLD_CODES

Line 3244: FROM AP_HOLDS AH1, AP_HOLD_CODES AHC

3240: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
3241: OR
3242: EXISTS
3243: (SELECT 1
3244: FROM AP_HOLDS AH1, AP_HOLD_CODES AHC
3245: WHERE AH1.RELEASE_LOOKUP_CODE IS NULL
3246: AND AI.INVOICE_ID = AH1.INVOICE_ID
3247: AND AH1.HOLD_LOOKUP_CODE = AHC.HOLD_LOOKUP_CODE
3248: AND NVL(AHC.POSTABLE_FLAG,'N') = 'N')),