[Home] [Help]
343: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
345: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
346: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
347: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
348: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
349: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
350: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
351: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add
427: financials_system_parameters fsp
428: WHERE pol.po_header_id = v_document_id
429: AND lkp1.lookup_code(+) = pol.contract_type
430: AND lkp1.lookup_type(+) = decode(pol.order_type_lookup_code,
489: FROM po_lines_draft_all pol, --CLM Apprvl
490: po_lines_draft_all po2, -- CLM Apprvl
491: po_lookup_codes lkp1,
492: mtl_system_items_kfv msi,
493: mtl_units_of_measure muom, -- bug 2401933.add
494: financials_system_parameters fsp
495: WHERE pol.po_header_id = v_document_id
496: AND nvl(pol.draft_id, -1) = nvl(v_draft_id, -1)
497: AND lkp1.lookup_code(+) = pol.contract_type
535: mtl_system_items_kfv msi,
536: hr_locations_all hrl,
537: hz_locations hz,
538: org_organization_definitions ood,
539: mtl_units_of_measure muom, -- Bug 2401933.add
540: financials_system_parameters fsp
541: where PLL.PO_RELEASE_ID = v_document_id
542: and PLL.po_line_id = POL.po_line_id
543: and PLL.ship_to_location_id = HRL.location_id (+)