APPS.BOM_BOMRWUIT_XMLP_PKG SQL Statements

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

Line: 41

      SELECT fifst.id_flex_num
      FROM fnd_id_flex_structures fifst
      WHERE fifst.application_id = 401
      AND fifst.id_flex_code = flex_code
      AND fifst.id_flex_structure_code = flex_structure_code
      AND fifst.enabled_flag = 'Y'
      AND fifst.freeze_flex_definition_flag = 'Y'
      ORDER BY fifst.id_flex_num;

Line: 172

     SELECT
       BOM_IMPLOSION_TEMP_S.NEXTVAL
     INTO L_SEQUENCE_ID
     FROM
       DUAL;

Line: 185

       SELECT
         ITEM_NUMBER
       INTO L_ITEM_NUMBER
       FROM
         MTL_ITEM_FLEXFIELDS
       WHERE ITEM_ID = P_ITEM_ID
         AND ORGANIZATION_ID = LP_ORG_ID;

Line: 226

       FOR C1 IN (SELECT
                    ORGANIZATION_ID
                  FROM
                    MTL_PARAMETERS MP
                  WHERE MASTER_ORGANIZATION_ID = (
                    SELECT
                      MASTER_ORGANIZATION_ID
                    FROM
                      MTL_PARAMETERS
                    WHERE ORGANIZATION_ID = LP_ORG_ID )
                    AND MP.ORGANIZATION_ID IN (
                    SELECT
                      ORGANIZATION_ID
                    FROM
                      ORG_ACCESS_VIEW
                    WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
                      AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
         N := N + 1;

Line: 257

       L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (
                                  SEQUENCE_ID,LOWEST_ITEM_ID,CURRENT_ITEM_ID,PARENT_ITEM_ID,
                                  CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
                                  LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
                                  REQUEST_ID,ORGANIZATION_ID) ';

Line: 263

         INSERT INTO BOM_IMPLOSION_TEMP
           (SEQUENCE_ID
           ,LOWEST_ITEM_ID
           ,CURRENT_ITEM_ID
           ,PARENT_ITEM_ID
           ,CURRENT_LEVEL
           ,SORT_CODE
           ,CURRENT_ASSEMBLY_TYPE
           ,LAST_UPDATE_DATE
           ,LAST_UPDATED_BY
           ,CREATION_DATE
           ,CREATED_BY
           ,REQUEST_ID
           ,ORGANIZATION_ID)
         VALUES   (L_SEQUENCE_ID
           ,P_ITEM_ID
           ,P_ITEM_ID
           ,P_ITEM_ID
           ,0
           ,L_SORT_CODE
           ,NULL
           ,SYSDATE
           ,1
           ,SYSDATE
           ,1
           ,P_CONC_REQUEST_ID
           ,LP_ORG_ID);

Line: 291

         L_STR := L_STR || 'SELECT /*+ ORDERED */ DISTINCT ' || TO_CHAR(L_SEQUENCE_ID) || ', MSI.INVENTORY_ITEM_ID,MSI.INVENTORY_ITEM_ID,MSI.INVENTORY_ITEM_ID
                                                ,0, ' || L_SORT_CODE || ', ' || 'NULL' || ', SYSDATE, 1, SYSDATE, 1,' || TO_CHAR(P_CONC_REQUEST_ID) || ', ' || TO_CHAR(LP_ORG_ID) || '  FROM MTL_SYSTEM_ITEMS MSI,
                                                    MTL_ITEM_CATEGORIES MIC,
                                                    MTL_CATEGORIES MC
                                                WHERE ' || P_ASSY_WHERE || '
                                                AND    MSI.BOM_ENABLED_FLAG = ''Y''
                                                AND    MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
                                                AND    MSI.ORGANIZATION_ID = ' || TO_CHAR(LP_ORG_ID) || '
                                                AND    MIC.ORGANIZATION_ID = ' || TO_CHAR(LP_ORG_ID) || '
                                                AND    MIC.CATEGORY_SET_ID = ' || TO_CHAR(P_SET_ID) || '
                                                AND    MIC.CATEGORY_ID = MC.CATEGORY_ID
                                                AND    MC.STRUCTURE_ID =
                                                ' || TO_CHAR(P_CATEGORY_STRUCTURE_ID) || '
                                                AND    ' || P_CAT_WHERE ;

Line: 401

       SELECT
         ML.MEANING
       INTO STATUS_NAME
       FROM
         MFG_LOOKUPS ML
       WHERE ML.LOOKUP_CODE = 6
         AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';

Line: 410

     SELECT
       ML.MEANING
     INTO STATUS_NAME
     FROM
       ENG_REVISED_ITEMS ERI,
       MFG_LOOKUPS ML
     WHERE ERI.REVISED_ITEM_SEQUENCE_ID = REVISED_ITEM_SEQUENCE_ID
       AND ML.LOOKUP_CODE = ERI.STATUS_TYPE
       AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';

Line: 430

     SELECT
       ORG.ORGANIZATION_CODE
     INTO ORG_CODE
     FROM
       ORG_ORGANIZATION_DEFINITIONS ORG
     WHERE ORG.ORGANIZATION_ID = GET_ORGCODE.ORGANIZATION_ID;