DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on PO_LINE_LOCATIONS

Line 594: po_line_locations PLL,

590: INTO l_po_dist_count
591: FROM po_distributions_all POD,
592: ap_invoice_distributions AID,
593: ap_invoices ai,
594: po_line_locations PLL,
595: po_lines PL
596: WHERE POD.po_distribution_id = AID.po_distribution_id
597: AND POD.line_location_id = PLL.line_location_id
598: AND PLL.po_line_id = PL.po_line_id

Line 701: po_line_locations PLL

697:
698: SELECT count(*)
699: INTO l_final_close_count
700: FROM ap_invoice_lines AIL,
701: po_line_locations PLL
702: WHERE AIL.invoice_id = p_line_rec.invoice_id
703: AND AIL.line_number = p_line_rec.line_number
704: AND AIL.po_line_location_id = PLL.line_location_id
705: AND PLL.closed_code = 'FINALLY CLOSED';

Line 2073: FROM po_line_locations_all

2069: INTO l_currency_code
2070: FROM po_headers_all
2071: WHERE po_header_id IN
2072: (SELECT po_header_id
2073: FROM po_line_locations_all
2074: WHERE line_location_id = p_line_location_id)
2075: AND rownum < 2;
2076:
2077: EXCEPTION