[Home] [Help]
259: -- from po_line_csr and po_line_loc_csr.
260: --
261: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
317: pol.quantity,
318: pol.unit_price,
319: nvl(pol.amount, pol.quantity * pol.unit_price)
320: FROM po_lines pol,
321: mtl_system_items_kfv msi,
322: mtl_units_of_measure muom, -- bug 2401933.add
323: financials_system_parameters fsp
324: WHERE pol.po_header_id = v_document_id
325: AND pol.item_id = msi.inventory_item_id(+)
336:
337: /* Bug# 1530303: kagarwal
338: ** Desc: We need to change the where clause as the item
339: ** may not be an inventory item. For this case we should
340: ** have an outer join with the mtl_system_items_kfv.
341: **
342: ** Changed the condition:
343: ** pol.item_id = msi.inventory_item_id
344: ** to pol.item_id = msi.inventory_item_id(+)
383: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
384: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
385: FROM po_lines pol,
386: po_line_locations pll,
387: mtl_system_items_kfv msi,
388: hr_locations_all hrl,
389: hz_locations hz,
390: org_organization_definitions ood,
391: mtl_units_of_measure muom, -- Bug 2401933.add