The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
where item_id = item_id_v
and lot_id = lot_id_v
and doc_type = 'GRDI'
and reason_code = fnd_profile.value('PMI$REASON_CODE');
SELECT QC_GRADE into qc_grade_v
from ic_tran_cmp_vw1 where trans_id = trans_id_vi;
SELECT QC_GRADE into qc_grade_v
from ic_tran_cmp_vw1 where trans_id = trans_id_v;
select count(*) into NO_OF_SAMPLES_v from qc_smpl_mst
where batch_id = BATCH_ID_VI;
select count(*) into COMPLET_SAMPLES_v from qc_smpl_mst
where batch_id = BATCH_ID_VI
and sample_status in ('ACCEPT','REJECT');
select count(*) into PASSED_SAMPLES_V from qc_smpl_mst
where batch_id = BATCH_ID_VI
and sample_status = 'ACCEPT';
select count(distinct to_char(item_id)||to_char(TRANS_DATE,'dd/mm/yy hh24:mi:ss'))
into ADJUST_BATCH_V
from ic_tran_cmp_vw1
where doc_id = BATCH_ID_VI
and doc_type = 'PROD'
and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');
SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
BtchHdr.ACTUAL_CMPLT_DATE))
into INGREDIENT_VALUE_V
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
AND BtchDtl.LINE_TYPE=-1;
SELECT gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE)
into L_ITEM_VALUE
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = Itemmst.ITEM_ID
AND BtchDtl.LINE_TYPE=1
AND BtchDtl.ITEM_ID=ITEM_ID_VI
AND BtchDtl.LINE_NO=LINE_NO_VI;
SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
4,BtchHdr.ACTUAL_CMPLT_DATE,
BtchHdr.EXPCT_CMPLT_DATE)))
into L_TOTAL_BATCH_OUT_VALUE
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
AND BtchDtl.LINE_TYPE=1;
SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
4,BtchHdr.ACTUAL_CMPLT_DATE,
BtchHdr.EXPCT_CMPLT_DATE)))
into INGREDIENT_VALUE_V
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
AND BtchDtl.LINE_TYPE=-1;
SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
into BYPRODUCT_VALUE_V
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
AND BtchDtl.LINE_TYPE=2;
SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
4,BtchHdr.ACTUAL_CMPLT_DATE,
BtchHdr.EXPCT_CMPLT_DATE)))
into BYPRODUCT_VALUE_V
FROM
PM_BTCH_HDR BtchHdr,
PM_MATL_DTL BtchDtl,
IC_ITEM_MST ItemMst
WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
AND BtchDtl.LINE_TYPE=2;
SELECT shift_start,shift_duration
FROM ps_schd_dtl sd, ps_schd_hdr sh,
mr_shcl_dtl sc, mr_shdy_dtl sl
WHERE sd.schedule_id = sh.schedule_id
AND sd.Calendar_id = sc.Calendar_id
AND sc.shopday_no = sl.shopday_no
AND sh.schedule = SCHEDULE_V
AND sd.orgn_code = PLANT_CODE_V
AND trunc(sc.calendar_date) = trunc(batch_day_V)
order by shift_start;
SELECT PLANT_CODE
into PLANT_CODE_V1
from pm_btch_hdr
where batch_id = batch_id_vi;
select count(*) into count2_v
from ps_schd_dtl sd, ps_schd_hdr sh
where sd.schedule_id = sh.schedule_id
and sh.schedule = SCHEDULE_VI
AND sd.orgn_code = PLANT_CODE_V1;