[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
CF_INSTANCE := 'and worp.instance_id = ((SELECT bre.instance_id FROM PER_ALL_PEOPLE_F PAPF,bom_resource_employees bre,bom_resources br1
WHERE trunc(sysdate) between papf.effective_start_date and papf.effective_end_date AND
PAPF.PERSON_ID = BRE.PERSON_ID and
bre.instance_id =worp.instance_id and
bre.resource_id =br.resource_id and
br1.resource_id=bre.resource_id and
br1.organization_id=worp.organization_id and
bre.organization_id = worp.organization_id and
papf.full_name = ''' || P_INSTANCE || '''
and br1.resource_type=2)
union
(select bre.instance_id
FROM MTL_SYSTEM_ITEMS_KFV MSIK, bom_resource_equipments bre,bom_resources br2
WHERE BRE.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND
MSIK.ITEM_TYPE = ''EQ'' and
bre.instance_id =worp.instance_id and
bre.resource_id = br.resource_id and
br2.resource_id=bre.resource_id and
br2.organization_id=worp.organization_id and
bre.organization_id = worp.organization_id
and br2.resource_type=1 and
MSIK.CONCATENATED_SEGMENTS =''' || P_INSTANCE || '''))';
(select department_id from bom_departments where department_code=''' || RTRIM(P_OWNING_DEPARTMENT) || '''
and organization_id=worp.organization_id)';
SELECT
MEANING
INTO P_DIS_SORT_BY
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'EAM_WSREP_SORT_BY'
AND LOOKUP_CODE = P_SORT_BY;
SELECT
CONCATENATED_SEGMENTS
INTO P_DIS_RBITEM
FROM
MTL_SYSTEM_ITEMS_B_KFV
WHERE INVENTORY_ITEM_ID = P_REBUILD_ITEM
AND ROWNUM < 2;