The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
LINE_NO
INTO P_LINE_NO
FROM
FM_MATL_DTL
WHERE INVENTORY_ITEM_ID = LINE_NOCFFORMULA.ITEM_ID
AND LINE_TYPE = 1
AND FORMULA_ID = LINE_NOCFFORMULA.FORMULA_ID;
SELECT
SCALE_QTY
INTO BATCHQTY
FROM
FM_IBOM_DTL
WHERE TOP_FORMULA_ID = P_FORMULA_ID
AND EXPLODE_SEQ = SUBSTR(BATCH_QTYCFFORMULA.EXPLODE_SEQ
,1
,LENGTH(BATCH_QTYCFFORMULA.EXPLODE_SEQ) - 3) || '001';
SELECT
FORMULA_QTY
INTO FORMQTY
FROM
FM_IBOM_DTL
WHERE TOP_FORMULA_ID = P_FORMULA_ID
AND EXPLODE_SEQ = SUBSTR(FORM_QTYCFFORMULA.EXPLODE_SEQ
,1
,LENGTH(FORM_QTYCFFORMULA.EXPLODE_SEQ) - 3) || '001';
SELECT
DISTINCT
STD_QTY
INTO STANDARDQTY
FROM
FM_IBOM_DTL
WHERE LINE_TYPE = 1
AND TOP_FORMULA_ID = P_FORMULA_ID
AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM
AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (
SELECT
FM_MATL_DTL.INVENTORY_ITEM_ID
FROM
FM_MATL_DTL
WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
AND LINE_TYPE = 1
AND LINE_NO = 1 )
AND LINE_NO = 1;
SELECT
I_QTY_UOM
INTO UOM1
FROM
FM_IBOM_DTL
WHERE TOP_FORMULA_ID = P_FORMULA_ID
AND EXPLODE_SEQ = SUBSTR(UOMCFFORMULA.EXPLODE_SEQ
,1
,LENGTH(UOMCFFORMULA.EXPLODE_SEQ) - 3) || '001';
SELECT Count(1)
INTO P_Count
FROM FM_IBOM_HDR ;