APPS.AP_IAW_PKG dependencies on AP_HOLD_CODES

Line 3565: ap_hold_codes hc

3561: null,
3562: il.line_number line_number
3563: from ap_invoice_lines_all il,
3564: po_lines_all pl,
3565: ap_hold_codes hc
3566: where il.invoice_id = p_invoice_id
3567: and il.po_line_location_id is not null
3568: and pl.po_line_id = il.po_line_id
3569: and pl.unit_price <> il.unit_price

Line 3609: ap_hold_codes hc

3605: null,
3606: il.line_number line_number
3607: from ap_invoice_lines_all il,
3608: po_line_locations_all ll,
3609: ap_hold_codes hc
3610: where il.invoice_id = p_invoice_id
3611: and il.po_line_location_id = ll.line_location_id
3612: and il.quantity_invoiced > ll.quantity_received
3613: and hc.hold_lookup_code = 'QTY REC'

Line 3652: ap_hold_codes hc

3648: null,
3649: il.line_number line_number
3650: from ap_invoice_lines_all il,
3651: po_line_locations_all ll,
3652: ap_hold_codes hc
3653: where il.invoice_id = p_invoice_id
3654: and il.po_line_location_id = ll.line_location_id
3655: and il.quantity_invoiced > ll.quantity
3656: and hc.hold_lookup_code = 'QTY ORD'

Line 3695: ap_hold_codes hc

3691: null,
3692: il.line_number line_number
3693: from ap_invoice_lines_all il,
3694: po_line_locations_all ll,
3695: ap_hold_codes hc
3696: where il.invoice_id = p_invoice_id
3697: and il.po_line_location_id = ll.line_location_id
3698: and il.amount > ll.amount
3699: and hc.hold_lookup_code = 'AMT ORD'

Line 3738: ap_hold_codes hc

3734: null,
3735: il.line_number line_number
3736: from ap_invoice_lines_all il,
3737: po_line_locations_all ll,
3738: ap_hold_codes hc
3739: where il.invoice_id = p_invoice_id
3740: and il.po_line_location_id = ll.line_location_id
3741: and il.amount > ll.amount_received
3742: and hc.hold_lookup_code = 'AMT REC'