APPS.PO_WF_REQ_NOTIFICATION dependencies on MTL_SYSTEM_ITEMS_KFV

Line 50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

46: TYPE line_record IS RECORD (
47:
48: req_line_id po_requisition_lines.requisition_line_id%TYPE,
49: line_num po_requisition_lines.line_num%TYPE,
50: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
51: item_revision po_requisition_lines.item_revision%TYPE,
52: item_desc po_requisition_lines.item_description%TYPE,
53: -- uom po_requisition_lines.unit_meas_lookup_code%TYPE, -- Bug 2401933.remove
54: uom mtl_units_of_measure.unit_of_measure_tl%TYPE, -- Bug 2401933.add

Line 1225: mtl_system_items_kfv msi,

1221: rql.suggested_vendor_location,
1222: rql.currency_code,
1223: rql.currency_unit_price
1224: FROM po_requisition_lines rql,
1225: mtl_system_items_kfv msi,
1226: hr_locations_all hrt,
1227: mtl_units_of_measure muom, -- bug 2401933.add
1228: per_all_people_f per -- Bug 3404451
1229: WHERE rql.requisition_header_id = v_document_id

Line 1478: mtl_system_items_kfv msi,

1474: decode(rql.source_type_code, 'VENDOR',rql.suggested_vendor_location,''),
1475: rql.currency_code,
1476: rql.currency_unit_price
1477: FROM po_requisition_lines rql,
1478: mtl_system_items_kfv msi,
1479: hr_locations_all hrt,
1480: per_all_people_f per, -- Bug 3404451
1481: mtl_units_of_measure muom, -- bug 2401933.add
1482: org_organization_definitions org