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

Line 607: FROM ap_holds H,

603: AND I.invoice_id = p_invoice_id
604: AND D.po_distribution_id is NULL
605: AND (( D.match_status_flag = 'S')
606: AND (NOT EXISTS (SELECT 'X'
607: FROM ap_holds H,
608: ap_hold_codes C
609: WHERE H.invoice_id = D.invoice_id
610: AND H.line_location_id is null
611: AND H.hold_lookup_code = C.hold_lookup_code

Line 656: FROM ap_holds H,

652: AND NVL(PER.adjustment_period_flag, 'N') = 'N'
653: AND I.invoice_id = p_invoice_id
654: AND (( D.match_status_flag = 'S')
655: AND (NOT EXISTS (SELECT 'X'
656: FROM ap_holds H,
657: ap_hold_codes C
658: WHERE H.invoice_id = D.invoice_id
659: AND H.line_location_id is null
660: AND H.hold_lookup_code = C.hold_lookup_code

Line 714: FROM ap_holds H,

710: AND I.invoice_id = p_invoice_id
711: AND T.po_distribution_id is NULL
712: AND (( T.match_status_flag = 'S')
713: AND (NOT EXISTS (SELECT 'X'
714: FROM ap_holds H,
715: ap_hold_codes C
716: WHERE H.invoice_id = T.invoice_id
717: AND H.line_location_id is null
718: AND H.hold_lookup_code = C.hold_lookup_code

Line 753: FROM ap_holds H,

749: AND NVL(PER.adjustment_period_flag, 'N') = 'N'
750: AND I.invoice_id = p_invoice_id
751: AND (( T.match_status_flag = 'S')
752: AND (NOT EXISTS (SELECT 'X'
753: FROM ap_holds H,
754: ap_hold_codes C
755: WHERE H.invoice_id = T.invoice_id
756: AND H.line_location_id is null
757: AND H.hold_lookup_code = C.hold_lookup_code