APPS.AP_IAW_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 3608: po_line_locations_all ll,

3604: null,
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

Line 3651: po_line_locations_all ll,

3647: null,
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

Line 3694: po_line_locations_all ll,

3690: null,
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

Line 3737: po_line_locations_all ll,

3733: null,
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

Line 3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

3965: funcmode IN VARCHAR2,
3966: resultout OUT NOCOPY VARCHAR2) AS
3967:
3968: l_po_header_id po_headers_all.po_header_id%TYPE;
3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%TYPE;
3972: l_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
3973: l_internal_contact_email ap_invoices_all.internal_contact_email%TYPE;

Line 3999: po_line_locations_all pll,

3995: -- 1. complex work owners
3996: cursor owners_csr is
3997: select ail.line_number, pll.work_approver_id, wfr.name
3998: from ap_invoice_lines_all ail,
3999: po_line_locations_all pll,
4000: ap_invoices_all ai,
4001: wf_local_roles wfr
4002: where ai.invoice_id = l_invoice_id
4003: and ai.invoice_id = ail.invoice_id