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_REQ_NOTIFICATION_R11 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

3:
4: TYPE line_record IS RECORD (
5:
6: line_num po_requisition_lines.line_num%TYPE,
7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,

Line 790: mtl_system_items_kfv msi,

786: per.full_name,
787: rql.suggested_vendor_name,
788: rql.suggested_vendor_location
789: FROM po_requisition_lines rql,
790: mtl_system_items_kfv msi,
791: hr_locations hrt,
792: per_people_f per
793: WHERE rql.requisition_header_id = v_document_id
794: AND NVL(rql.cancel_flag,'N') = 'N'

Line 1058: mtl_system_items_kfv msi,

1054: per.full_name,
1055: rql.suggested_vendor_name,
1056: rql.suggested_vendor_location
1057: FROM po_requisition_lines rql,
1058: mtl_system_items_kfv msi,
1059: hr_locations hrt,
1060: per_people_f per
1061: WHERE rql.requisition_header_id = v_document_id
1062: AND NVL(rql.cancel_flag,'N') = 'N'