DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on PO_LINES_ALL

Line 11375: FROM po_lines_all POL , po_line_locations_all PLL

11371: OR (l_inv_dist_list(i).retained_invoice_dist_id IS NOT NULL and l_inv_dist_list(i).po_distribution_id IS NOT NULL)) THEN
11372:
11373: BEGIN
11374: SELECT POL.retainage_rate INTO l_retainage_rate
11375: FROM po_lines_all POL , po_line_locations_all PLL
11376: WHERE PLL.po_header_id = POL.po_header_id
11377: AND PLL.po_line_id = POL.po_line_id
11378: AND PLL.line_location_id = l_po_line_location_id
11379: AND PLL.po_header_id = l_ref_doc_trx_id;

Line 16495: po_lines_all PL,

16491: D.matched_uom_lookup_code rcv_uom,
16492: rsl.item_id rcv_item_id
16493: FROM ap_invoice_distributions_all D,
16494: po_distributions_all PD,
16495: po_lines_all PL,
16496: po_line_locations_all PLL,
16497: rcv_transactions RTXN,
16498: rcv_shipment_lines RSL
16499: WHERE D.invoice_distribution_id = c_inv_dist_id