DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on WF_ITEMS

Line 2188: -- ' FROM wf_items' || l_db_link ||

2184:
2185: else
2186:
2187: --sql_stmt := ' SELECT item_key, item_type ' ||
2188: -- ' FROM wf_items' || l_db_link ||
2189: -- ' WHERE item_type in (''MSCEXPWF'',''MRPEXWFS'') '||
2190: -- ' AND item_key like '''|| to_char(arg_plan_id) || '-%''';
2191: sql_stmt:= ' SELECT ITEM_KEY, ITEM_TYPE '||
2192: ' FROM WF_ITEM_ATTRIBUTE_VALUES '||

Line 2218: update wf_items

2214: from wf_item_activity_statuses_h
2215: where item_type = l_item_type
2216: and item_key = l_item_key);
2217:
2218: update wf_items
2219: set end_date = sysdate
2220: where item_type = l_item_type
2221: and item_key = l_item_key;
2222: