The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
attribute_type, attribute_source
into l_type, l_col
from flm_seq_attributes
where attribute_id = p_attribute_id;
select
attribute_type, attribute_source
into l_type, l_col
from flm_seq_attributes
where attribute_id = p_attribute_id;
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID AND BOM_ITEM_TYPE = 5' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID AND BOM_ITEM_TYPE = 1' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT RULE_NAME NAME_VALUE, RULE_ID ID_VALUE ' ||
'FROM MTL_ATP_RULES ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, ITEM_CATALOG_GROUP_ID ID_VALUE ' ||
'FROM MTL_ITEM_CATALOG_GROUPS_KFV ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT PICKING_RULE_NAME NAME_VALUE, PICKING_RULE_ID ID_VALUE ' ||
'FROM MTL_PICKING_RULES ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT HAZARD_CLASS NAME_VALUE, HAZARD_CLASS_ID ID_VALUE ' ||
'FROM PO_HAZARD_CLASSES ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID AND ENG_ITEM_FLAG = ''Y''' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
'FROM OE_SETS ' ||
'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''ARRIVAL''' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
'FROM OE_SETS ' ||
'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''SHIP''' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT TRANSACTION_TYPE_CODE NAME_VALUE, TRANSACTION_TYPE_ID ID_VALUE ' ||
'FROM OE_TRANSACTION_TYPES_ALL ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT NAME NAME_VALUE, ORGANIZATION_ID ID_VALUE ' ||
'FROM HR_ALL_ORGANIZATION_UNITS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT ORGANIZATION_CODE NAME_VALUE, ORGANIZATION_ID ID_VALUE ' ||
'FROM MTL_PARAMETERS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'FROM PA_PROJECTS_ALL ' ||
'WHERE :ORG_ID IS NOT NULL ' ||
'union ' ||
'select project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'from mrp_seiban_numbers ' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
'FROM PA_TASKS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
'FROM OE_SETS ' ||
'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''LINE''' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT NAME NAME_VALUE, ORDER_SOURCE_ID ID_VALUE ' ||
'FROM OE_ORDER_SOURCES ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT NAME NAME_VALUE, CONFIG_HDR_ID ID_VALUE ' ||
'FROM CZ_CONFIG_HDRS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'FROM PA_PROJECTS_ALL ' ||
'WHERE :ORG_ID IS NOT NULL ' ||
'union ' ||
'select project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'from mrp_seiban_numbers ' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
'FROM PA_TASKS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
'FROM MTL_SYSTEM_ITEMS_KFV ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT SCHEDULE_GROUP_NAME NAME_VALUE, SCHEDULE_GROUP_ID ID_VALUE ' ||
'FROM WIP_SCHEDULE_GROUPS ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT KANBAN_CARD_NUMBER NAME_VALUE, KANBAN_CARD_ID ID_VALUE ' ||
'FROM MTL_KANBAN_CARDS ' ||
'WHERE ORGANIZATION_ID = :ORG_ID' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'FROM PA_PROJECTS_ALL ' ||
'WHERE :ORG_ID IS NOT NULL ' ||
'union ' ||
'select project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
'from mrp_seiban_numbers ' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
'FROM PA_TASKS ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';
'SELECT NAME_VALUE, ID_VALUE FROM ' ||
'(' ||
'SELECT concatenated_segments NAME_VALUE, CATEGORY_ID ID_VALUE ' ||
'FROM MTL_CATEGORIES_KFV ' ||
'WHERE :ORG_ID IS NOT NULL' ||
')';