APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 498: mtl_system_items items

494: draft_lines.un_number_id,
495: draft_lines.hazard_class_id
496: -- Bug 13506679
497: FROM po_lines_draft_all draft_lines,
498: mtl_system_items items
499: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
500: AND draft_lines.draft_id = l_draft_id_tbl(i)
501: AND draft_lines.item_id = items.inventory_item_id(+)
502: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 1154: UPDATE mtl_system_items

1150: l_index := l_update_item_queue.NEXT(l_index);
1151: END LOOP;
1152: /*
1153: FORALL i IN 1..l_update_item_id_tbl.COUNT
1154: UPDATE mtl_system_items
1155: SET description = l_update_item_desc_tbl(i),
1156: last_update_date = sysdate,
1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,

Line 1169: UPDATE mtl_system_items_tl

1165:
1166: d_position := 280;
1167:
1168: FORALL i IN 1..l_update_item_id_tbl.COUNT
1169: UPDATE mtl_system_items_tl
1170: SET description = l_update_item_desc_tbl(i)
1171: WHERE inventory_item_id = l_update_item_id_tbl(i)
1172: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id
1173: AND language = USERENV('LANG');