The following lines contain the word 'select', 'insert', 'update' or 'delete':
select wip_transactions_s.nextval into x_moveTxnID from dual;
select mtl_material_transactions_s.nextval into x_cplTxnID from dual;
select mtl_material_transactions_s.nextval into x_batchID from dual;
select mtl_material_transactions_s.nextval into x_txnHeaderID from dual;
select mtl_material_transactions_s.nextval into x_compHeaderID from dual;
wip_logger.entryPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
p_params => l_params,
x_returnStatus => l_returnStatus);
SELECT 1 into l_temp
FROM wip_period_balances wpb
WHERE wpb.acct_period_id = l_periodID
AND wpb.wip_entity_id = moveData.wipEntityID
AND wpb.organization_id = moveData.orgID;
select count(*) into l_totalNum
from qa_results
where collection_id = moveData.qaCollectionID;
select primary_item_id, line_id
into primaryItemID, lineID
from wip_discrete_jobs
where organization_id = moveData.orgID
and wip_entity_id = moveData.wipEntityID;
insert into wip_move_txn_interface
(transaction_id,
group_id,
source_code,
last_update_date,
last_updated_by,
creation_date,
created_by,
process_phase,
process_status,
transaction_type,
organization_id,
wip_entity_id,
entity_type,
transaction_date,
acct_period_id,
fm_operation_seq_num,
fm_intraoperation_step_type,
to_operation_seq_num,
to_intraoperation_step_type,
transaction_quantity,
transaction_uom,
scrap_account_id,
qa_collection_id,
primary_item_id,
line_id,
fm_operation_code,
fm_department_id,
fm_department_code,
to_operation_code,
to_department_id,
to_department_code,
primary_quantity,
primary_uom)
values(moveData.txnID,
groupID,
'Discrete Station Move',
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
2, -- move processing
processStatus,
moveData.txnType,
moveData.orgID,
moveData.wipEntityID,
1,
sysdate,
moveData.periodID,
moveData.fmOp,
moveData.fmStep,
moveData.toOp,
moveData.toStep,
moveData.txnQty,
moveData.txnUOM,
moveData.scrapAcctID,
qaCollectionID,
primaryItemID,
lineID,
fmOpCode,
fmDeptID,
fmDeptCode,
toOpCode,
toDeptID,
toDeptCode,
moveData.txnQty,
moveData.txnUOM
);
p_insertAssy => fnd_api.g_false,
p_do_backflush => fnd_api.g_false,
p_assy_header_id => moveData.assyHeaderID,
p_mtl_header_id => moveData.compHeaderID,
x_returnStatus => x_returnStatus);
wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
p_procReturnStatus => x_returnStatus,
p_msg => x_errMessage,
x_returnStatus => l_returnStatus);
select nvl(sum(primary_reservation_quantity), 0)
into l_inv_primary_rsv_quantity
from mtl_reservations
where demand_source_line_id = p_orderLineID
and organization_id = p_orgID
and supply_source_type_id = 13;
SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
INTO l_ispjm_org
FROM pjm_org_parameters
WHERE organization_id=p_organization_id;
SELECT Nvl(subinventory_type,1)
INTO l_sub_type
FROM mtl_secondary_inventories
WHERE secondary_inventory_name = p_subinventory_code
AND organization_id = p_organization_id;
SELECT a.inventory_location_id,
a.concatenated_segments,
nvl( a.description, -1)
FROM mtl_item_locations_kfv a,mtl_secondary_locators b
WHERE b.organization_id = p_Organization_Id
AND b.inventory_item_id = p_Inventory_Item_Id
AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
AND b.subinventory_code = p_Subinventory_Code
AND a.inventory_location_id = b.secondary_locator
AND a.concatenated_segments LIKE (p_concatenated_segments)
AND inv_material_status_grp.is_status_applicable
( p_wms_installed,
NULL,
p_transaction_type_id,
NULL,
NULL,
p_Organization_Id,
p_Inventory_Item_Id,
p_Subinventory_Code,
a.inventory_location_id,
NULL,
NULL,
'L') = 'Y'
ORDER BY 2;
SELECT inventory_location_id,
concatenated_segments,
description
FROM mtl_item_locations_kfv
WHERE organization_id = p_Organization_Id
AND subinventory_code = p_Subinventory_Code
AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
AND concatenated_segments LIKE (p_concatenated_segments )
AND inv_material_status_grp.is_status_applicable
( p_wms_installed,
NULL,
p_transaction_type_id,
NULL,
NULL,
p_Organization_Id,
p_Inventory_Item_Id,
p_Subinventory_Code,
inventory_location_id,
NULL,
NULL,
'L') = 'Y'
ORDER BY 2;
SELECT a.inventory_location_id,
inv_project.get_locator(a.inventory_location_id,
a.organization_id) concatenated_segments,
nvl( a.description, -1)
FROM mtl_item_locations_kfv a,mtl_secondary_locators b
WHERE b.organization_id = p_Organization_Id
AND b.inventory_item_id = p_Inventory_Item_Id
AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
AND b.subinventory_code = p_Subinventory_Code
AND a.inventory_location_id = b.secondary_locator
AND a.concatenated_segments like (p_concatenated_segments )
AND nvl(a.project_id,-1) = nvl(p_project_id, -1)
AND nvl(a.task_id, -1) = nvl(p_task_id, -1)
AND inv_material_status_grp.is_status_applicable
( p_wms_installed,
NULL,
p_transaction_type_id,
NULL,
NULL,
p_Organization_Id,
p_Inventory_Item_Id,
p_Subinventory_Code,
a.inventory_location_id,
NULL,
NULL,
'L') = 'Y'
ORDER BY 2;
SELECT inventory_location_id,
inv_project.get_locator(inventory_location_id,
organization_id) concatenated_segments,
description
FROM mtl_item_locations_kfv
WHERE organization_id = p_Organization_Id
AND subinventory_code = p_Subinventory_Code
AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
AND concatenated_segments LIKE (p_concatenated_segments )
AND nvl(project_id,-1) = nvl(p_project_id, -1)
AND nvl(task_id, -1) = nvl(p_task_id, -1)
AND inv_material_status_grp.is_status_applicable
( p_wms_installed,
NULL,
p_transaction_type_id,
NULL,
NULL,
p_Organization_Id,
p_Inventory_Item_Id,
p_Subinventory_Code,
inventory_location_id,
NULL,
NULL,
'L') = 'Y'
ORDER BY 2;