The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT D.CONCATENATED_SEGMENTS,D.description,D.primary_uom_code,C.PARENT_LOT_NUMBER,C.LOT_NUMBER,
to_char(GR.RESULT_ID),A.TEST_CODE,A.TEST_DESC,A.TEST_CLASS,
B.TEST_METHOD_CODE, B.TEST_METHOD_DESC,B.RESOURCES,B.TEST_REPLICATE,
C.LAB_ORGANIZATION_ID, C.SAMPLE_ID,C.SAMPLE_NO,C.SAMPLE_DESC,
C.SUBINVENTORY, gr.test_by_date, gr.planned_Resource, gr.planned_result_date,
MIL.concatenated_segments, c.revision,
c.source_subinventory, MIL1.concatenated_segments,c.source --RLNAGARA B5738147
from GMD_RESULTS GR,
GMD_QC_TESTS_VL A,
GMD_TEST_METHODS B,
GMD_SAMPLES C,
mtl_system_items_kfv D,
-- mtl_lot_numbers E,
mtl_parameters MP,
mtl_item_locations_kfv MIL,
mtl_item_locations_kfv MIL1 --RLNAGARA B5738147
WHERE GR.SAMPLE_ID = l_event_key AND
GR.SAMPLE_ID=C.SAMPLE_ID AND
NVL(L_TEST_ID,GR.TEST_ID)=A.TEST_ID AND
A.TEST_METHOD_ID=B.TEST_METHOD_ID AND
C.ORGANIZATION_ID=D.ORGANIZATION_ID AND
-- C.INVENTORY_ITEM_ID=E.INVENTORY_ITEM_ID(+) AND
C.INVENTORY_ITEM_ID= D.INVENTORY_ITEM_ID AND
-- C.ORGANIZATION_ID = E.ORGANIZATION_ID AND
-- C.LOT_NUMBER = E.LOT_NUMBER AND
C.organization_id = mp.organization_id AND
MIL.organization_id(+) = C.organization_id AND
MIL.inventory_location_id(+) = C.locator_id AND
MIL1.organization_id(+) = C.organization_id AND --RLNAGARA B5738147
MIL1.inventory_location_id(+) = C.source_locator_id; --RLNAGARA B5738147
select nvl( text, '')
from wf_Resources where name = 'WF_ADMIN_ROLE'
and language = userenv('LANG') ;
SELECT organization_code
FROM mtl_parameters
WHERE organization_id = l_qc_lab_org_id;
select application_id into l_application_id
from fnd_application where application_short_name='GMD';
select user_name into l_user from fnd_user
where user_id=Approver.user_id;
select user_name into l_user from fnd_user
where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
Into l_sequence_id
From dual;
--insert into rg_debug(vdata) values(l_itemkey);
ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
transactionIdIn => l_result_id,
approverIn => Approver,
transactionTypeIn => l_transaction_type,
forwardeeIn => ame_util.emptyApproverRecord);
select application_id into l_application_id
from fnd_application where application_short_name='GMD';
select user_name into l_user from fnd_user
where user_id=Approver.user_id;
select user_name into l_user from fnd_user
where
user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
transactionIdIn => l_event_key,
approverIn => Approver,
transactionTypeIn => l_transaction_type,
forwardeeIn => ame_util.emptyApproverRecord);