DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on PO_LINE_LOCATIONS

Line 609: po_line_locations PLL

605:
606: SELECT count(*)
607: INTO l_final_close_count
608: FROM ap_invoice_lines AIL,
609: po_line_locations PLL
610: WHERE AIL.invoice_id = p_line_rec.invoice_id
611: AND AIL.line_number = p_line_rec.line_number
612: AND AIL.po_line_location_id = PLL.line_location_id
613: AND PLL.closed_code = 'FINALLY CLOSED';

Line 746: po_line_locations PLL,

742: INTO l_po_dist_count
743: FROM po_distributions_all POD,
744: ap_invoice_distributions AID,
745: ap_invoices ai,
746: po_line_locations PLL,
747: po_lines PL
748: WHERE POD.po_distribution_id = AID.po_distribution_id
749: AND POD.line_location_id = PLL.line_location_id
750: AND PLL.po_line_id = PL.po_line_id

Line 2148: FROM po_line_locations_all

2144: INTO l_currency_code
2145: FROM po_headers_all
2146: WHERE po_header_id IN
2147: (SELECT po_header_id
2148: FROM po_line_locations_all
2149: WHERE line_location_id = p_line_location_id)
2150: AND rownum < 2;
2151:
2152: EXCEPTION