APPS.BOM_CSTRCTCR_XMLP_PKG SQL Statements

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

Line: 22

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

Line: 59

	CREATE_WHERE_ITEM1 := ' msi.inventory_item_id in (select inventory_item_id from mtl_system_items MSLT where ';

Line: 71

	CREATE_WHERE_CAT1 := 'mc.category_id in (select category_id from mtl_categories MCT where ';

Line: 90

      SELECT
        NVL(FC.EXTENDED_PRECISION
           ,FC.PRECISION),
        NVL(FC.PRECISION
           ,0)
      INTO P_EXT_PRECISION,P_PRECISION
      FROM
        ORG_ORGANIZATION_DEFINITIONS O,
        GL_SETS_OF_BOOKS GL,
        MTL_PARAMETERS P,
        FND_CURRENCIES FC
      WHERE O.ORGANIZATION_ID = ORG_ID
        AND P.ORGANIZATION_ID = ORG_ID
        AND O.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
        AND FC.CURRENCY_CODE = GL.CURRENCY_CODE;