The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
inv.transaction_id
, inv.transaction_type_id
, inv.transaction_action_id
, inv.transfer_organization_id
, inv.transaction_date
, inv.organization_id
, inv.transaction_quantity
, inv.subinventory_code
, inv.transfer_subinventory
FROM
MTL_MATERIAL_TRANSACTIONS inv
, hr_organization_information hoi
WHERE inv.organization_id = hoi.organization_id
AND hoi.org_information_context = 'Accounting Information'
AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
AND inv.transaction_type_id IN (21,3,12,2)
AND inv.transaction_action_id IN (21,3,12,2)
AND NVL(inv.mvt_stat_status,'NEW') = 'NEW'
AND inv.transaction_date BETWEEN p_start_date AND p_end_date;
SELECT
inv.transaction_id
, inv.transaction_type_id
, inv.transaction_action_id
, inv.transfer_organization_id
, inv.transaction_date
, inv.organization_id
, inv.transaction_quantity
, inv.subinventory_code
, inv.transfer_subinventory
FROM
MTL_MATERIAL_TRANSACTIONS inv
, hr_organization_information hoi
WHERE inv.organization_id = hoi.organization_id
AND hoi.org_information_context = 'Accounting Information'
AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
AND inv.transaction_id = p_movement_transaction.mtl_transaction_id
AND inv.transaction_type_id IN (21,3,12,2)
AND inv.transaction_action_id IN (21,3,12,2)
AND NVL(inv.mvt_stat_status,'NEW') = 'NEW';
SELECT
inv.freight_code
, inv.transaction_type_id
, inv.transaction_action_id
, inv.transaction_id
, inv.organization_id
, inv.transfer_organization_id
, inv.transaction_uom
-- , inv.transaction_date timezone support donot populate transaction date again
, inv.primary_quantity
, inv.inventory_item_id
, si.description
/*
, nvl(cst.item_cost,0)+decode(sign(transaction_quantity),-1,0,
nvl(inv.transfer_cost,0))
*/
FROM
MTL_MATERIAL_TRANSACTIONS inv
, MTL_SYSTEM_ITEMS si
--, CST_ITEM_COSTS_FOR_GL_VIEW cst
WHERE inv.organization_id = si.organization_id
AND inv.inventory_item_id = si.inventory_item_id
--AND inv.organization_id = cst.organization_id(+)
--AND inv.inventory_item_id = cst.inventory_item_id(+)
AND inv.transaction_id = x_movement_transaction.mtl_transaction_id;
SELECT
item_cost
FROM
CST_ITEM_COSTS_FOR_GL_VIEW
WHERE organization_id = x_movement_transaction.from_organization_id
AND inventory_item_id = x_movement_transaction.inventory_item_id;
PROCEDURE Update_INV_Transactions
( p_movement_transaction IN
INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_procedure_name CONSTANT VARCHAR2(30) := 'Update_INV_Transactions';
UPDATE MTL_MATERIAL_TRANSACTIONS
SET mvt_stat_status = 'PROCESSED'
, movement_id = p_movement_transaction.movement_id
WHERE transaction_id = p_movement_transaction.mtl_transaction_id;
END Update_INV_Transactions;