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 757: FROM ap_holds H,

753: AND I.invoice_id = p_invoice_id
754: AND D.po_distribution_id is NULL
755: AND (( D.match_status_flag = 'S')
756: AND (NOT EXISTS (SELECT 'X'
757: FROM ap_holds H,
758: ap_hold_codes C
759: WHERE H.invoice_id = D.invoice_id
760: AND H.line_location_id is null
761: AND H.hold_lookup_code = C.hold_lookup_code

Line 807: FROM ap_holds H,

803: AND NVL(PER.adjustment_period_flag, 'N') = 'N'
804: AND I.invoice_id = p_invoice_id
805: AND (( D.match_status_flag = 'S')
806: AND (NOT EXISTS (SELECT 'X'
807: FROM ap_holds H,
808: ap_hold_codes C
809: WHERE H.invoice_id = D.invoice_id
810: AND H.line_location_id is null
811: AND H.hold_lookup_code = C.hold_lookup_code

Line 866: FROM ap_holds H,

862: AND I.invoice_id = p_invoice_id
863: AND T.po_distribution_id is NULL
864: AND (( T.match_status_flag = 'S')
865: AND (NOT EXISTS (SELECT 'X'
866: FROM ap_holds H,
867: ap_hold_codes C
868: WHERE H.invoice_id = T.invoice_id
869: AND H.line_location_id is null
870: AND H.hold_lookup_code = C.hold_lookup_code

Line 906: FROM ap_holds H,

902: AND NVL(PER.adjustment_period_flag, 'N') = 'N'
903: AND I.invoice_id = p_invoice_id
904: AND (( T.match_status_flag = 'S')
905: AND (NOT EXISTS (SELECT 'X'
906: FROM ap_holds H,
907: ap_hold_codes C
908: WHERE H.invoice_id = T.invoice_id
909: AND H.line_location_id is null
910: AND H.hold_lookup_code = C.hold_lookup_code