APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 475: mtl_system_items items

471: draft_lines.ip_category_id,
472: draft_lines.original_interface_line_id, -- bug5149827
473: items.allow_item_desc_update_flag
474: FROM po_lines_draft_all draft_lines,
475: mtl_system_items items
476: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
477: AND draft_lines.draft_id = l_draft_id_tbl(i)
478: AND draft_lines.item_id = items.inventory_item_id(+)
479: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 1063: UPDATE mtl_system_items

1059: l_index := l_update_item_queue.NEXT(l_index);
1060: END LOOP;
1061: /*
1062: FORALL i IN 1..l_update_item_id_tbl.COUNT
1063: UPDATE mtl_system_items
1064: SET description = l_update_item_desc_tbl(i),
1065: last_update_date = sysdate,
1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,

Line 1078: UPDATE mtl_system_items_tl

1074:
1075: d_position := 280;
1076:
1077: FORALL i IN 1..l_update_item_id_tbl.COUNT
1078: UPDATE mtl_system_items_tl
1079: SET description = l_update_item_desc_tbl(i)
1080: WHERE inventory_item_id = l_update_item_id_tbl(i)
1081: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id
1082: AND language = USERENV('LANG');