APPS.GME_GMEBCHYV_XMLP_PKG SQL Statements

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

Line: 78

      SELECT
        PLAN_QTY,
        DTL_UM
      INTO PLANQTY,ITEMUM
      FROM
        GME_MATERIAL_DETAILS PMD
      WHERE PMD.LINE_TYPE = 1
        AND PMD.BATCH_ID = cf_formula_qty.BATCH_ID
        AND INVENTORY_ITEM_ID = (
        SELECT
          INVENTORY_ITEM_ID
        FROM
          GMD_RECIPE_VALIDITY_RULES
        WHERE RECIPE_VALIDITY_RULE_ID = cf_formula_qty.RECIPE_VALIDITY_RULE_ID )
        AND ORGANIZATION_ID = P_ORG_ID;

Line: 94

      SELECT
        PLAN_QTY,
        DTL_UM
      INTO PLANQTY,ITEMUM
      FROM
        GME_MATERIAL_DETAILS PMD
      WHERE PMD.LINE_TYPE = 1
        AND PMD.LINE_NO = 1
        AND PMD.BATCH_ID = cf_formula_qty.BATCH_ID
        AND ORGANIZATION_ID = P_ORG_ID;

Line: 179

      SELECT
        COUNT(1)
      FROM
        FND_DUAL
      WHERE EXISTS (
        SELECT
          FORMULALINE_ID
        FROM
          GME_SCALE_DETAIL
        WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID );

Line: 190

      SELECT
        QTY
      FROM
        GME_SCALE_DETAIL
      WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID;

Line: 196

      SELECT
        INVENTORY_ITEM_ID
      FROM
        GMD_RECIPE_VALIDITY_RULES
      WHERE RECIPE_VALIDITY_RULE_ID = cf_plan_qty_itemumformula.RECIPE_VALIDITY_RULE_ID;

Line: 202

      SELECT
        PRIMARY_UOM_CODE
      FROM
        MTL_SYSTEM_ITEMS_B
      WHERE ORGANIZATION_ID = P_ORG_ID
        AND INVENTORY_ITEM_ID = V_ITEM_ID;

Line: 209

      SELECT
        QTY,
        DETAIL_UOM
      FROM
        FM_MATL_DTL
      WHERE FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID
        AND ORGANIZATION_ID = P_ORG_ID
        AND INVENTORY_ITEM_ID = X_ITEM_ID
        AND LINE_TYPE = 1;

Line: 219

      SELECT
        PLAN_QTY,
        DTL_UM
      FROM
        GME_MATERIAL_DETAILS
      WHERE BATCH_ID = cf_plan_qty_itemumformula.BATCH_ID
        AND INVENTORY_ITEM_ID = X_ITEM_ID
        AND LINE_TYPE = 1;

Line: 228

      SELECT
        QTY
      FROM
        GME_SCALE_DETAIL
      WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID;

Line: 234

      SELECT
        SCRAP_FACTOR
      FROM
        FM_MATL_DTL
      WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID
        AND FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID
        AND LINE_TYPE = - 1;

Line: 242

      SELECT
        FORMULALINE_ID,
        QTY,
        DETAIL_UOM,
        SCALE_TYPE,
        LINE_TYPE,
        INVENTORY_ITEM_ID,
        SCALE_MULTIPLE,
        SCALE_ROUNDING_VARIANCE,
        ROUNDING_DIRECTION,
        CONTRIBUTE_YIELD_IND
      FROM
        FM_MATL_DTL
      WHERE FORMULA_ID = cf_plan_qty_itemumformula.FORMULA_ID;

Line: 360

            INSERT INTO GME_SCALE_DETAIL(FORMULALINE_ID,LINE_TYPE,ITEM_ID,QTY,ITEM_UM,SCALE_TYPE,CONV_QTY)
            VALUES   (X_SCALE_TAB(I).LINE_NO
              , X_SCALE_TAB(I).LINE_TYPE
              ,X_SCALE_TAB(I).INVENTORY_ITEM_ID
              , X_SCALE_TAB(I).QTY
              , X_SCALE_TAB(I).DETAIL_UOM
              , X_SCALE_TAB(I).SCALE_TYPE
              , X_SCALE_TAB(I).QTY);

Line: 424

    DELETE FROM GME_SCALE_DETAIL;

Line: 513

  FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER IS
   pragma autonomous_transaction;

Line: 516

    DELETE FROM GME_SCALE_DETAIL;

Line: 519

  END CF_DELETE_TRANSFORMULA;

Line: 523

    DELETE FROM GME_SCALE_DETAIL;

Line: 545

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;