APPS.BOM_BOMRBOMC_XMLP_PKG SQL Statements

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

Line: 10

      SELECT
        REVISION
      FROM
        MTL_ITEM_REVISIONS MIR
      WHERE INVENTORY_ITEM_ID = ITEM_ID
        AND ORGANIZATION_ID = ORG_ID
        AND MIR.EFFECTIVITY_DATE <= TO_DATE(LP_REVISION_DATE
             ,'YYYY/MM/DD HH24:MI:SS')
        AND ( ( P_IMPL_FLAG = 2 )
      OR ( P_IMPL_FLAG = 1
        AND IMPLEMENTATION_DATE IS NOT NULL ) )
      ORDER BY
        EFFECTIVITY_DATE,
        REVISION;

Line: 77

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

      SELECT
        O.ORGANIZATION_NAME
      INTO L_ORGANIZATION_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS O
      WHERE O.ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 222

        SELECT
          ITEM_NUMBER
        INTO L_SPECIFIC_ITEM
        FROM
          MTL_ITEM_FLEXFIELDS
        WHERE ITEM_ID = P_ITEM_ID
          AND ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 233

        SELECT
          CATEGORY_SET_NAME
        INTO L_CATEGORY_SET
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;

Line: 242

      SELECT
        SUBSTR(L1.MEANING
              ,1
              ,40),
        SUBSTR(L2.MEANING
              ,1
              ,4),
        SUBSTR(L3.MEANING
              ,1
              ,40),
        SUBSTR(L4.MEANING
              ,1
              ,4),
        SUBSTR(L5.MEANING
              ,1
              ,4)
      INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
      FROM
        MFG_LOOKUPS L1,
        MFG_LOOKUPS L2,
        MFG_LOOKUPS L3,
        MFG_LOOKUPS L4,
        MFG_LOOKUPS L5
      WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
        AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
        AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
        AND L2.LOOKUP_CODE = P_IMPL_FLAG
        AND L3.LOOKUP_TYPE = 'BOM_SELECTION_TYPE'
        AND L3.LOOKUP_CODE = P_RANGE_OPTION_TYPE
        AND L4.LOOKUP_TYPE = 'SYS_YES_NO'
        AND L4.LOOKUP_CODE = P_PRINT_OPTION1_FLAG
        AND L5.LOOKUP_TYPE = 'SYS_YES_NO'
        AND L5.LOOKUP_CODE = P_PLAN_FACTOR_FLAG;

Line: 276

      SELECT
        SUBSTR(L1.MEANING
              ,1
              ,40),
        SUBSTR(L2.MEANING
              ,1
              ,40)
      INTO L_ALT_OPTION,L_ORDER_BY
      FROM
        MFG_LOOKUPS L1,
        MFG_LOOKUPS L2
      WHERE L1.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
        AND L1.LOOKUP_CODE = P_ALT_OPTION_TYPE
        AND L2.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'
        AND L2.LOOKUP_CODE = P_ORDER_BY_TYPE;

Line: 305

      SELECT
        BOM_LISTS_S.NEXTVAL
      INTO L_SEQ_ID
      FROM
        DUAL;

Line: 340

      L_STR := 'INSERT INTO BOM_LISTS (SEQUENCE_ID, ASSEMBLY_ITEM_ID,
                                               ALTERNATE_DESIGNATOR) ';

Line: 343

        L_STR := L_STR || '  SELECT DISTINCT ' || TO_CHAR(L_SEQ_ID) || ',
                                 ' || TO_CHAR(P_ITEM_ID) || ',
                                 bbom.alternate_bom_designator
                          FROM   bom_bill_of_materials bbom
                          WHERE  bbom.organization_id = ' || TO_CHAR(P_ORGANIZATION_ID) || '
                          AND    bbom.assembly_item_id = ' || TO_CHAR(P_ITEM_ID);

Line: 350

        L_STR := L_STR || '  SELECT DISTINCT ' || TO_CHAR(L_SEQ_ID) || ',
                                 msi.inventory_item_id,
                                 bbom.alternate_bom_designator
                          FROM   mtl_item_categories mic,
                                 mtl_system_items msi,
                                 mtl_categories mc,
                                 bom_bill_of_materials bbom
                          WHERE  ' || P_ASSY_WHERE || '
                          AND    msi.inventory_item_id = mic.inventory_item_id
                          AND    msi.organization_id =
                                 ' || TO_CHAR(P_ORGANIZATION_ID) || '
                          AND    mic.organization_id =
                                 ' || TO_CHAR(P_ORGANIZATION_ID) || '
                          AND    mic.category_set_id =
                                 ' || TO_CHAR(P_CATEGORY_SET_ID) || '
                          AND    mic.category_id = mc.category_id
                          AND    mc.structure_id =
                                 ' || TO_CHAR(P_CATEGORY_STRUCTURE_ID) || '
                          AND    ' || P_CAT_WHERE || '
                          AND    msi.inventory_item_id = bbom.assembly_item_id
                          AND    msi.organization_id = bbom.organization_id
                   	 AND 	msi.bom_enabled_flag = ''Y''';

Line: 504

      SELECT
        DESCRIPTION
      INTO L_DESC
      FROM
        MTL_DESCRIPTIVE_ELEMENTS
      WHERE ITEM_CATALOG_GROUP_ID = L_CATALOG_GROUP_ID
        AND ELEMENT_NAME = L_ELEMENT_NAME;

Line: 512

      SELECT
        MIN(DESCRIPTION)
      INTO L_DESC
      FROM
        MTL_DESCRIPTIVE_ELEMENTS
      WHERE ELEMENT_NAME = L_ELEMENT_NAME;