APPS.BOM_BOMRBOMS_XMLP_PKG SQL Statements

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

Line: 88

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

Line: 99

        SELECT
          CATEGORY_SET_NAME
        INTO L_CATEGORY_SET
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;

Line: 112

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

Line: 125

      SELECT
        SUBSTR(L1.MEANING
              ,1
              ,40),
        SUBSTR(L2.MEANING
              ,1
              ,40),
        SUBSTR(L3.MEANING
              ,1
              ,40),
        SUBSTR(L4.MEANING
              ,1
              ,40)
      INTO L_EXPLODE_OPTION,L_ALT_OPTION,L_RANGE_OPTION,L_ORDER_BY
      FROM
        MFG_LOOKUPS L1,
        MFG_LOOKUPS L2,
        MFG_LOOKUPS L3,
        MFG_LOOKUPS L4
      WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
        AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
        AND L2.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
        AND L2.LOOKUP_CODE = P_ALT_OPTION_TYPE
        AND L3.LOOKUP_TYPE = 'BOM_SELECTION_TYPE'
        AND L3.LOOKUP_CODE = P_RANGE_OPTION_TYPE
        AND L4.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'
        AND L4.LOOKUP_CODE = P_ORDER_BY_TYPE;

Line: 154

      SELECT
        SUBSTR(L1.MEANING
              ,1
              ,4),
        SUBSTR(L2.MEANING
              ,1
              ,4)
      INTO L_YES,L_NO
      FROM
        MFG_LOOKUPS L1,
        MFG_LOOKUPS L2
      WHERE L1.LOOKUP_TYPE = 'SYS_YES_NO'
        AND L1.LOOKUP_CODE = 1
        AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
        AND L2.LOOKUP_CODE = 2;

Line: 246

        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_ORGANIZATION_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: 282

      SELECT
        BOM_LISTS_S.NEXTVAL
      INTO P_SEQUENCE_ID1
      FROM
        DUAL;

Line: 289

        INSERT INTO BOM_LISTS
          (ORGANIZATION_ID
          ,SEQUENCE_ID
          ,ALTERNATE_DESIGNATOR)
        VALUES   (T_ORG_CODE_LIST(I)
          ,P_SEQUENCE_ID1
          ,I);

Line: 300

        TABLE_NAME := 'Select_sequence';

Line: 301

        SELECT
          BOM_LISTS_S.NEXTVAL
        INTO L_SEQ_ID
        FROM
          DUAL;

Line: 346

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

Line: 351

          L_STR := L_STR || 'SELECT DISTINCT ' || 'TO_CHAR(:b_l_seq_id)' || ',:b_P_ITEM_ID' || ',bbom.alternate_bom_designator
                   		FROM bom_bill_of_materials bbom
                            WHERE bbom.assembly_item_id = ' || ':b_P_ITEM_ID' || ' and bbom.organization_id =' || ':b_P_ORGANIZATION_ID';

Line: 414

          L_STR := L_STR || '  SELECT
                                   DISTINCT ' || ':b_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_ASS_BETWEEN || '
                            AND    msi.inventory_item_id = mic.inventory_item_id
                            AND    msi.organization_id =
                                   ' || ':b_P_ORGANIZATION_ID' || '
                            AND    mic.organization_id =
                                   ' || ':b_P_ORGANIZATION_ID' || '
                            AND    mic.category_id = mc.category_id
                            AND    mic.category_set_id =
                                   ' || ':b_P_CATEGORY_SET_ID' || '
                            AND    mc.structure_id =
                                   ' || ':b_P_CATEGORY_STRUCTURE_ID' || '
                            AND    ' || P_CAT_BETWEEN || '
                            AND    msi.inventory_item_id = bbom.assembly_item_id
                            AND    msi.organization_id = bbom.organization_id
                     	 AND 	msi.bom_enabled_flag = ''Y''';

Line: 590

      DELETE FROM BOM_LISTS
       WHERE SEQUENCE_ID = P_SEQUENCE_ID1;

Line: 642

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

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

Line: 733

      SELECT
        MEANING
      INTO DUMMY
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'WIP_SUPPLY'
        AND LOOKUP_CODE = WIP_SUPPLY_TYPE;

Line: 754

    SELECT
      REV.DESCRIPTION
    INTO REV_DESC
    FROM
      MTL_ITEM_REVISIONS REV
    WHERE REV.INVENTORY_ITEM_ID = ITEM_ID
      AND REV.ORGANIZATION_ID = ORG_ID
      AND REV.REVISION = ACTIVE_REV;

Line: 771

    SELECT
      ORGANIZATION_NAME
    INTO ORG_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS ORG
    WHERE ORG.ORGANIZATION_ID = M_ORG_ID;

Line: 786

    SELECT
      DESCRIPTION
    INTO ITEM_DESC
    FROM
      MTL_SYSTEM_ITEMS_TL
    WHERE ORGANIZATION_ID = ORG_ID
      AND INVENTORY_ITEM_ID = ITEM_ID
      AND LANGUAGE = USERENV('LANG');

Line: 806

    SELECT
      DESCRIPTION
    INTO ITEM_DESC
    FROM
      MTL_SYSTEM_ITEMS_TL
    WHERE ORGANIZATION_ID = ORG_ID
      AND INVENTORY_ITEM_ID = ITEM_ID
      AND LANGUAGE = USERENV('LANG');

Line: 826

    SELECT
      DESCRIPTION
    INTO ITEM_DESC
    FROM
      MTL_SYSTEM_ITEMS_TL
    WHERE ORGANIZATION_ID = ORG_ID
      AND INVENTORY_ITEM_ID = ITEM_ID
      AND LANGUAGE = USERENV('LANG');