APPS.BOM_CSTRPMDD_XMLP_PKG SQL Statements

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

Line: 11

        SELECT
          TRANSACTION_SOURCE_TYPE_NAME
        INTO SOURCE_TYPE_NAME
        FROM
          MTL_TXN_SOURCE_TYPES
        WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 58

      SELECT
        FRV.RESPONSIBILITY_NAME,
        TO_CHAR(FCR.REQUEST_DATE
               ,'YYYY/MM/DD HH24:MI:SS'),
        FAV.APPLICATION_NAME,
        FU.USER_NAME
      INTO CP_RESPONSIBILITY,CP_REQUEST_TIME,CP_APPLICATION,CP_REQUESTED_BY
      FROM
        FND_CONCURRENT_REQUESTS FCR,
        FND_RESPONSIBILITY_VL FRV,
        FND_APPLICATION_VL FAV,
        FND_USER FU
      WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
        AND FCR.RESPONSIBILITY_APPLICATION_ID = FRV.APPLICATION_ID
        AND FCR.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
        AND FRV.APPLICATION_ID = FAV.APPLICATION_ID
        AND FU.USER_ID = FCR.REQUESTED_BY;

Line: 84

      SELECT
        DISTINCT
        XFI.NAME,
        CCG.COST_GROUP,
        CCT.COST_TYPE,
        NVL(FC.PRECISION
           ,2),
        NVL(FC.EXTENDED_PRECISION
           ,5),
        CPP.PERIOD_NAME
      INTO CP_LEGAL_ENTITY,CP_COST_GROUP,CP_COST_TYPE,CP_PRECISION,CP_EXT_PRECISION,CP_PERIOD_NAME
      FROM
        CST_PAC_PERIODS CPP,
        XLE_FIRSTPARTY_INFORMATION_V XFI,
        FND_CURRENCIES FC,
        CST_COST_GROUPS CCG,
        CST_COST_TYPES CCT
      WHERE XFI.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
        AND CPP.PAC_PERIOD_ID = P_PERIOD_ID
        AND FC.CURRENCY_CODE = P_CURRENCY_CODE
        AND CCG.COST_GROUP_ID = P_COST_GROUP_ID
        AND CCT.COST_TYPE_ID = P_COST_TYPE_ID;

Line: 120

                   ,'Failed in MSTK/Select')*/NULL;

Line: 128

                   ,'Failed in GL#/Select')*/NULL;

Line: 248

      SELECT
        MEANING
      INTO CP_SORT_BY_COV
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'CST_SRS_PAC_BOM_CSTRPMDD_XMLP_PKG_SORT'
        AND LOOKUP_CODE = P_SORT_ID;

Line: 255

      SELECT
        MEANING
      INTO CP_TYPE_OPTION_COV
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'INV_SRS_DST_TYPE'
        AND LOOKUP_CODE = P_TYPE_OPTION
        AND ENABLED_FLAG = 'Y';

Line: 387

          RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
                 	    AND cst.description BETWEEN ''' || P_SOURCE_LO || ''' AND ''' || P_SOURCE_HI || ''' ');

Line: 390

          RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
                 	    AND cst.description BETWEEN >= ''' || P_SOURCE_LO || ''' ');

Line: 393

          RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
                 	    AND cst.description <= ''' || P_SOURCE_HI || ''' ');

Line: 478

      SELECT
        CATEGORY_SET_NAME
      INTO CAT_SET_NAME
      FROM
        MTL_CATEGORY_SETS
      WHERE CATEGORY_SET_ID = CAT_SET_ID;

Line: 502

        SELECT
          TRANSACTION_TYPE_NAME
        INTO TXN_TYPE_NAME
        FROM
          MTL_TRANSACTION_TYPES
        WHERE TRANSACTION_TYPE_ID = TXN_TYPE_ID;

Line: 527

        SELECT
          REASON_NAME
        INTO REASON_NAME
        FROM
          MTL_TRANSACTION_REASONS
        WHERE REASON_ID = TXN_REASON_ID;

Line: 599

        RETURN (', cst_cost_updates cst');

Line: 733

    SELECT
      CAH.AE_CATEGORY,
      CAH.ACCOUNTING_EVENT_ID,
      CAL.PO_DISTRIBUTION_ID
    INTO L_EVENT_TYPE,L_TRANSACTION_ID,L_PO_DISTRIBUTION_ID
    FROM
      CST_AE_HEADERS CAH,
      CST_AE_LINES CAL
    WHERE CAL.AE_LINE_ID = L_AE_LINE_ID
      AND CAH.AE_HEADER_ID = CAL.AE_HEADER_ID;

Line: 745

      SELECT
        PERIOD_END_DATE
      INTO L_PERIOD_END_DATE
      FROM
        CST_PAC_PERIODS CPP
      WHERE CPP.PAC_PERIOD_ID = P_PERIOD_ID;

Line: 752

      SELECT
        DECODE(POLL.MATCHING_BASIS
              ,'AMOUNT'
              ,1
              ,0),
        POLL.LINE_LOCATION_ID,
        DECODE(POLL.MATCHING_BASIS
              ,'AMOUNT'
              ,POLL.AMOUNT - NVL(POLL.AMOUNT_CANCELLED
                 ,0)
              ,POLL.QUANTITY - NVL(POLL.QUANTITY_CANCELLED
                 ,0)),
        DECODE(POLL.MATCHING_BASIS
              ,'AMOUNT'
              ,POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_CANCELLED
                 ,0)
              ,POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_CANCELLED
                 ,0)),
        NVL(POLL.MATCH_OPTION
           ,'P')
      INTO L_SERVICE_FLAG,L_PO_LINE_LOCATION_ID,L_SHIPMENT_QTY,L_DIST_QTY,L_MATCH_OPTION
      FROM
        PO_DISTRIBUTIONS_ALL POD,
        PO_LINE_LOCATIONS_ALL POLL,
        PO_LINES_ALL POL
      WHERE POD.PO_DISTRIBUTION_ID = L_PO_DISTRIBUTION_ID
        AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
        AND POLL.PO_LINE_ID = POL.PO_LINE_ID
        AND NVL(POLL.ACCRUE_ON_RECEIPT_FLAG
         ,'N') = 'N';

Line: 803

      SELECT
        DECODE(CAL.ACCOUNTED_DR
              ,NULL
              ,-1 * L_ACCRUAL_QTY
              ,L_ACCRUAL_QTY)
      INTO L_TXN_QUANTITY
      FROM
        CST_AE_LINES CAL
      WHERE CAL.AE_LINE_ID = L_AE_LINE_ID;