APPS.AP_INVOICES_UTILITY_PKG dependencies on PO_LINE_LOCATIONS

Line 997: l_shipment_type po_line_locations.shipment_type%TYPE;

993:
994: FUNCTION get_release_number(l_invoice_id IN NUMBER)
995: RETURN VARCHAR2 IS
996: po_release_number VARCHAR2(25) := 'UNMATCHED';
997: l_shipment_type po_line_locations.shipment_type%TYPE;
998:
999: CURSOR po_shipment_type_cursor IS
1000: SELECT DISTINCT(pll.shipment_type)
1001: FROM ap_invoice_lines L,

Line 1002: po_line_locations PLL

998:
999: CURSOR po_shipment_type_cursor IS
1000: SELECT DISTINCT(pll.shipment_type)
1001: FROM ap_invoice_lines L,
1002: po_line_locations PLL
1003: WHERE L.invoice_id = l_invoice_id
1004: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1005: FROM ap_invoice_lines AIL
1006: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'

Line 1026: po_line_locations PLL,

1022:
1023: CURSOR po_release_number_cursor IS
1024: SELECT DISTINCT(PRL.release_num)
1025: FROM ap_invoice_lines L,
1026: po_line_locations PLL,
1027: po_releases PRL
1028: WHERE L.invoice_id = l_invoice_id
1029: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1030: FROM ap_invoice_lines AIL

Line 3220: po_line_locations_all pll

3216: WHERE i.invoice_id = P_Invoice_Id
3217: AND EXISTS
3218: (SELECT ail.invoice_id
3219: FROM ap_invoice_lines_all ail,
3220: po_line_locations_all pll
3221: WHERE ail.invoice_id = i.invoice_id
3222: AND ail.po_line_location_id = pll.line_location_id
3223: AND ail.org_id = pll.org_id
3224: AND pll.closed_code = 'FINALLY CLOSED');