APPS.AP_INVOICES_UTILITY_PKG dependencies on PO_LINE_LOCATIONS

Line 1069: l_shipment_type po_line_locations.shipment_type%TYPE;

1065:
1066: FUNCTION get_release_number(l_invoice_id IN NUMBER)
1067: RETURN VARCHAR2 IS
1068: po_release_number VARCHAR2(25) := 'UNMATCHED';
1069: l_shipment_type po_line_locations.shipment_type%TYPE;
1070:
1071: CURSOR po_shipment_type_cursor IS
1072: SELECT DISTINCT(pll.shipment_type)
1073: FROM ap_invoice_lines L,

Line 1074: po_line_locations PLL

1070:
1071: CURSOR po_shipment_type_cursor IS
1072: SELECT DISTINCT(pll.shipment_type)
1073: FROM ap_invoice_lines L,
1074: po_line_locations PLL
1075: WHERE L.invoice_id = l_invoice_id
1076: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1077: FROM ap_invoice_lines AIL
1078: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'

Line 1098: po_line_locations PLL,

1094:
1095: CURSOR po_release_number_cursor IS
1096: SELECT DISTINCT(PRL.release_num)
1097: FROM ap_invoice_lines L,
1098: po_line_locations PLL,
1099: po_releases PRL
1100: WHERE L.invoice_id = l_invoice_id
1101: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1102: FROM ap_invoice_lines AIL

Line 3293: po_line_locations_all pll

3289: WHERE i.invoice_id = P_Invoice_Id
3290: AND EXISTS
3291: (SELECT ail.invoice_id
3292: FROM ap_invoice_lines_all ail,
3293: po_line_locations_all pll
3294: WHERE ail.invoice_id = i.invoice_id
3295: AND ail.po_line_location_id = pll.line_location_id
3296: AND ail.org_id = pll.org_id
3297: AND pll.closed_code = 'FINALLY CLOSED');