[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(mobile_transaction_mode, wip_constants.background)
into txnMode
from wip_parameters
where organization_id = orgID;
EXECUTE IMMEDIATE 'select ' || sequence || '.nextval from dual'
INTO nextVal;
select msikfv.inventory_item_id,
msikfv.concatenated_segments,
msikfv.description,
msikfv.organization_id,
msikfv.primary_uom_code,
msikfv.lot_control_code,
msikfv.auto_lot_alpha_prefix,
msikfv.start_auto_lot_number,
msikfv.serial_number_control_code,
msikfv.auto_serial_alpha_prefix,
msikfv.start_auto_serial_number,
msikfv.location_control_code,
msikfv.revision_qty_control_code,
msikfv.restrict_locators_code,
msikfv.restrict_subinventories_code,
msikfv.shelf_life_code,
msikfv.shelf_life_days,
msikfv.inventory_asset_flag,
msikfv.allowed_units_lookup_code,
msikfv.mtl_transactions_enabled_flag,
null, -- projectID, assume locator is not available
null -- taskID, assume locator is not available
from mtl_system_items_kfv msikfv
where msikfv.inventory_item_id = itemID
and msikfv.organization_id = orgID;
select mil.project_id,
mil.task_id
from mtl_item_locations mil
where inventory_location_id = locatorID
and organization_id = orgID;
select wdj.wip_entity_id,
wdj.organization_id,
wen.wip_entity_name,
wdj.job_type,
wdj.description,
wdj.primary_item_id,
wdj.status_type,
wdj.wip_supply_type,
wdj.line_id,
wl.line_code,
wdj.scheduled_start_date,
wdj.scheduled_completion_date,
wdj.start_quantity,
wdj.quantity_completed,
wdj.quantity_scrapped,
wdj.completion_subinventory,
wdj.completion_locator_id,
wdj.project_id,
wdj.task_id,
wdj.end_item_unit_number
from wip_discrete_jobs wdj,
wip_lines wl,
wip_entities wen
where wdj.wip_entity_id = wipEntityID
AND wen.wip_entity_id = wipEntityID
AND wen.entity_type in (WIP_CONSTANTS.DISCRETE,
WIP_CONSTANTS.EAM)
AND wl.line_id (+)= wdj.line_id
AND wl.organization_id (+) = wdj.organization_id;
select user_name from fnd_user
where user_id = userID;
select organization_code from mtl_parameters
where organization_id = orgID;