APPS.GME_GMEMUSBV_XMLP_PKG SQL Statements

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

Line: 216

      SELECT
        PLAN_QTY
      INTO PLANQTY
      FROM
        GME_MATERIAL_DETAILS
      WHERE BATCH_ID = CF_BATCH_SIZEFORMULA.BATCH_ID
        AND INVENTORY_ITEM_ID = (
        SELECT
          INVENTORY_ITEM_ID
        FROM
          GMD_RECIPE_VALIDITY_RULES
        WHERE RECIPE_VALIDITY_RULE_ID = CF_BATCH_SIZEFORMULA.RECIPE_VALIDITY_RULE_ID );

Line: 229

      SELECT
        PLAN_QTY
      INTO PLANQTY
      FROM
        GME_MATERIAL_DETAILS
      WHERE BATCH_ID = CF_BATCH_SIZEFORMULA.BATCH_ID
        AND LINE_TYPE = 1
        AND LINE_NO = 1;

Line: 250

      SELECT
        DTL_UM
      INTO ITEMUM
      FROM
        GME_MATERIAL_DETAILS
      WHERE BATCH_ID = cf_itemumformula.BATCH_ID
        AND INVENTORY_ITEM_ID = (
        SELECT
          INVENTORY_ITEM_ID
        FROM
          GMD_RECIPE_VALIDITY_RULES
        WHERE RECIPE_VALIDITY_RULE_ID = cf_itemumformula.RECIPE_VALIDITY_RULE_ID );

Line: 263

      SELECT
        DTL_UM
      INTO ITEMUM
      FROM
        GME_MATERIAL_DETAILS
      WHERE BATCH_ID = cf_itemumformula.BATCH_ID
        AND LINE_TYPE = 1
        AND LINE_NO = 1;

Line: 292

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

Line: 303

      SELECT
        QTY
      FROM
        GME_SCALE_DETAIL
      WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID;

Line: 309

      SELECT
        INVENTORY_ITEM_ID
      FROM
        GMD_RECIPE_VALIDITY_RULES
      WHERE RECIPE_VALIDITY_RULE_ID = trans_qtyformula_005.RECIPE_VALIDITY_RULE_ID;

Line: 315

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

Line: 322

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

Line: 332

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

Line: 341

      SELECT
        QTY
      FROM
        GME_SCALE_DETAIL
      WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID;

Line: 347

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

Line: 355

      SELECT
        A.RECIPE_ID,
        B.ROUTING_ID,
        B.FORMULA_ID,
        B.PLAN_START_DATE
      FROM
        GME_BATCH_HEADER B,
        GMD_RECIPE_VALIDITY_RULES A
      WHERE B.BATCH_ID = PBATCH_ID
        AND B.RECIPE_VALIDITY_RULE_ID = A.RECIPE_VALIDITY_RULE_ID;

Line: 366

      SELECT
        ITEM_UM
      FROM
        GMD_ROUTINGS_B
      WHERE ROUTING_ID = P_ROUTING_ID;

Line: 372

      SELECT
        ROUTING_CLASS,
        ITEM_UM
      FROM
        GMD_ROUTINGS_B
      WHERE ROUTING_ID = PROUTING_ID;

Line: 379

      SELECT
        *
      FROM
        GME_SCALE_DETAIL
      WHERE LINE_TYPE in ( 1 , 2 );

Line: 385

      SELECT
        *
      FROM
        FM_MATL_DTL
      WHERE FORMULA_ID = trans_qtyformula_005.FORMULA_ID
        AND LINE_TYPE in ( 1 , 2 );

Line: 559

          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: 602

    DELETE FROM GME_SCALE_DETAIL;

Line: 643

    DELETE FROM GME_SCALE_DETAIL;

Line: 648

  FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER IS
   PRAGMA AUTONOMOUS_TRANSACTION;

Line: 651

    DELETE FROM GME_SCALE_DETAIL;

Line: 654

  END CF_DELETE_TRANSFORMULA;

Line: 673

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORG_ID;