APPS.GMD_ICR01USR_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

        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;

Line: 56

    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';

Line: 75

    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';

Line: 95

    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;

Line: 124

    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';

Line: 172

 SELECT Count(1)
 INTO	 P_Count
 FROM   FM_IBOM_HDR  ;