DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on AP_HOLDS

Line 1747: FROM ap_holds H,

1743: AND PER.application_id = 200
1744: AND NVL(PER.adjustment_period_flag, 'N') = 'N'
1745: AND D.match_status_flag = 'S'
1746: AND (NOT EXISTS (SELECT 'X'
1747: FROM ap_holds H,
1748: ap_hold_codes C
1749: WHERE H.invoice_id = D.invoice_id
1750: AND ( H.line_location_id is null OR H.line_location_id = PLL.line_location_id )
1751: AND H.hold_lookup_code = C.hold_lookup_code