eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_PO_NOTIFICATION dependencies on MTL_SYSTEM_ITEMS_KFV

Line 344: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

340: -- from po_line_csr and po_line_loc_csr.
341: --
342: TYPE line_num_tbl_type IS TABLE OF PO_LINES.line_num%TYPE;
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;

Line 425: mtl_system_items_kfv msi,

421: ,pol.LINE_NUM_DISPLAY
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

Line 449: ** have an outer join with the mtl_system_items_kfv.

445:
446: /* Bug# 1530303: kagarwal
447: ** Desc: We need to change the where clause as the item
448: ** may not be an inventory item. For this case we should
449: ** have an outer join with the mtl_system_items_kfv.
450: **
451: ** Changed the condition:
452: ** pol.item_id = msi.inventory_item_id
453: ** to pol.item_id = msi.inventory_item_id(+)

Line 492: mtl_system_items_kfv msi,

488: ,pol.LINE_NUM_DISPLAY
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)

Line 535: mtl_system_items_kfv msi,

531: --Bug 5563024 AMOUNT NOT SHOWN FOR A RELEASE SHIPMENT IN APPROVAL NOTIFICATION.
532: nvl(pll.amount, nvl(pll.price_override, pol.unit_price) * pll.quantity)
533: FROM po_lines_all pol, -- CLM apprvl
534: po_line_locations_all pll, -- CLM apprvl
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