APPS.BOM_CSTRPWDD_XMLP_PKG SQL Statements

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

Line: 25

          SELECT
            DISTINCT
            CLASS_TYPE
          INTO CL_TYPE
          FROM
            WIP_ACCOUNTING_CLASSES
          WHERE CLASS_CODE = P_CLASS_CODE;

Line: 52

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

      SELECT
        DISTINCT
        HR.NAME,
        CCG.COST_GROUP,
        CCT.COST_TYPE,
        CAH.PERIOD_NAME,
        NVL(FC.PRECISION
           ,2),
        NVL(FC.EXTENDED_PRECISION
           ,5)
      INTO CP_LEGAL_ENTITY,CP_COST_GROUP,CP_COST_TYPE,CP_PERIOD_NAME,P_CURRENCY_PRECISION,P_RATE_PRECISION
      FROM
        CST_AE_HEADERS CAH,
        HR_LEGAL_ENTITIES HR,
        FND_CURRENCIES FC,
        CST_COST_GROUPS CCG,
        CST_COST_TYPES CCT
      WHERE CAH.LEGAL_ENTITY_ID = HR.ORGANIZATION_ID
        AND FC.CURRENCY_CODE = P_CURRENCY_CODE
        AND CAH.COST_GROUP_ID = P_COST_GROUP_ID
        AND CCG.COST_GROUP_ID = CAH.COST_GROUP_ID
        AND CCT.COST_TYPE_ID = P_COST_TYPE_ID
        AND CAH.PERIOD_ID = P_PERIOD_ID;

Line: 114

        SELECT
          NVL(WE.WIP_ENTITY_NAME
             ,' ')
        INTO CP_WIP_ENTITY_NAME_COV
        FROM
          WIP_ENTITIES WE
        WHERE WE.WIP_ENTITY_ID = P_JOB;

Line: 125

        SELECT
          NVL(WL.LINE_CODE
             ,' ')
        INTO CP_LINE_CODE_COV
        FROM
          WIP_LINES WL
        WHERE WL.LINE_ID = P_LINE;

Line: 136

        SELECT
          NVL(ML.MEANING
             ,' ')
        INTO CP_TXN_TYPE_COV
        FROM
          MFG_LOOKUPS ML
        WHERE ML.LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE_SHORT'
          AND ML.LOOKUP_CODE = P_TRANS_TYPE;

Line: 148

        SELECT
          NVL(BD.DEPARTMENT_CODE
             ,' ')
        INTO CP_DEPARTMENT_CODE_COV
        FROM
          BOM_DEPARTMENTS BD
        WHERE BD.DEPARTMENT_ID = P_DEPARTMENT;

Line: 159

        SELECT
          NVL(CA.ACTIVITY
             ,' ')
        INTO CP_ACTIVITY_COV
        FROM
          CST_ACTIVITIES CA
        WHERE CA.ACTIVITY_ID = P_ACTIVITY;