The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT INVENTORY_ITEM_ID,
TRANSACTION_ID,
ORGANIZATION_ID,
PICK_COMPONENTS_FLAG,
PURCHASING_ITEM_FLAG,
SHIPPABLE_ITEM_FLAG,
CUSTOMER_ORDER_FLAG,
INTERNAL_ORDER_FLAG,
INVENTORY_ITEM_FLAG,
ENG_ITEM_FLAG,
INVENTORY_ASSET_FLAG,
PURCHASING_ENABLED_FLAG,
CUSTOMER_ORDER_ENABLED_FLAG,
INTERNAL_ORDER_ENABLED_FLAG,
SO_TRANSACTIONS_FLAG,
MTL_TRANSACTIONS_ENABLED_FLAG,
STOCK_ENABLED_FLAG,
BOM_ENABLED_FLAG,
BUILD_IN_WIP_FLAG,
CATALOG_STATUS_FLAG,
RETURNABLE_FLAG,
COLLATERAL_FLAG,
TAXABLE_FLAG,
ALLOW_ITEM_DESC_UPDATE_FLAG,
INSPECTION_REQUIRED_FLAG,
RECEIPT_REQUIRED_FLAG,
RFQ_REQUIRED_FLAG,
ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
ALLOW_UNORDERED_RECEIPTS_FLAG,
ALLOW_EXPRESS_DELIVERY_FLAG,
MRP_CALCULATE_ATP_FLAG,
END_ASSEMBLY_PEGGING_FLAG,
REPETITIVE_PLANNING_FLAG,
REPLENISH_TO_ORDER_FLAG,
ATP_COMPONENTS_FLAG,
ATP_FLAG,
DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
ENGINEERING_ECN_CODE,
SERVICEABLE_PRODUCT_FLAG,
PREVENTIVE_MAINTENANCE_FLAG,
TIME_BILLABLE_FLAG,
MATERIAL_BILLABLE_FLAG,
EXPENSE_BILLABLE_FLAG,
PRORATE_SERVICE_FLAG,
SERVICE_DURATION_PERIOD_CODE,
INVOICEABLE_ITEM_FLAG,
INVOICE_ENABLED_FLAG,
MUST_USE_APPROVED_VENDOR_FLAG,
OUTSIDE_OPERATION_FLAG,
COSTING_ENABLED_FLAG,
CYCLE_COUNT_ENABLED_FLAG,
AUTO_CREATED_CONFIG_FLAG,
/*CK 18NOV98 Added new attribute*/
CHECK_SHORTAGES_FLAG,
BOM_ITEM_TYPE,
CONTRACT_ITEM_TYPE_CODE,
--R12 FPC
GDSN_OUTBOUND_ENABLED_FLAG,
STYLE_ITEM_FLAG
FROM MTL_SYSTEM_ITEMS_INTERFACE
--3515652: Performance enhancements
WHERE ((organization_id = org_id) or (all_Org = 1))
AND set_process_id = xset_id
AND process_flag in (31, 32, 33, 34 , 35 , 45);
select meaning
from cs_lookups
where lookup_type = cp_lookup_type
and lookup_code = cp_lookup_code
and enabled_flag = 'Y';
if (cr.ALLOW_ITEM_DESC_UPDATE_FLAG <> 'Y' and
cr.ALLOW_ITEM_DESC_UPDATE_FLAG <> 'N') then
dumm_status := INVPUOPI.mtl_log_interface_err(
cr.organization_id,
user_id,
login_id,
prog_appid,
prog_id,
request_id,
cr.TRANSACTION_ID,
error_msg,
'ALLOW_ITEM_DESC_UPDATE_FLAG',
'MTL_SYSTEM_ITEMS_INTERFACE',
'INV_IOI_FLAG_Y_N',
err_text);
SELECT status
INTO status
FROM mtl_all_primary_uoms_vv
WHERE uom_code = cr.service_duration_period_code
AND uom_class = time_uom_class;
select process_flag into temp_proc_flag
from MTL_SYSTEM_ITEMS_INTERFACE
where inventory_item_id = cr.inventory_item_id
and set_process_id + 0 = xset_id
and process_flag in (31, 32, 33, 34 , 35 , 45)
and organization_id = cr.organization_id
and rownum < 2;
update MTL_SYSTEM_ITEMS_INTERFACE
set process_flag = DECODE(status,0,45,35)
where inventory_item_id = cr.inventory_item_id
and set_process_id + 0 = xset_id
and process_flag = 45
and organization_id = cr.organization_id;