APPS.BOM_CSTRIVTW_XMLP_PKG SQL Statements

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

Line: 23

      SELECT
        NVL(PROCESS_ENABLED_FLAG
           ,'N'),
        ORGANIZATION_CODE
      INTO L_PROCESS_ENABLED_FLAG,L_ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID1;

Line: 49

      SELECT
        SOB.CURRENCY_CODE
      INTO L_FCN_CURRENCY
      FROM
        GL_SETS_OF_BOOKS SOB,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE OOD.ORGANIZATION_ID = P_ORGANIZATION_ID1
        AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID;

Line: 58

      SELECT
        O.ORGANIZATION_NAME,
        O.ORGANIZATION_CODE,
        NVL(MINIMUM_ACCOUNTABLE_UNIT
           ,POWER(10
                ,NVL(-PRECISION
                   ,0)))
      INTO CP_ORG_NAME,CP_ORG_CODE,ROUND_UNIT
      FROM
        ORG_ORGANIZATION_DEFINITIONS O,
        FND_CURRENCIES FC
      WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
        AND O.ORGANIZATION_ID = P_ORGANIZATION_ID1;

Line: 87

	SELECT
          NVL(REQUESTED_BY
             ,-1),
          NVL(CONC_LOGIN_ID
             ,-1),
          NVL(PROGRAM_APPLICATION_ID
             ,-1),
          NVL(CONCURRENT_PROGRAM_ID
             ,-1)
        INTO L_USER_ID,L_LOGIN_ID,L_PROG_APPL_ID,L_PROG_ID
	FROM
          FND_CONCURRENT_REQUESTS
        WHERE REQUEST_ID = P_CONC_REQUEST_ID
          AND ROWNUM = 1;

Line: 142

          SELECT
            DESCRIPTION,
            WIP_ENTITY_ID,
            ITEM_TYPE,
            SPECIFIC_ITEM_ID,
            CATEGORY_SET_ID,
            CATEGORY_ID,
            SPECIFIC_PROJECT_ID,
            ADJUSTMENT_ACCOUNT,
            TO_CHAR(CUTOFF_DATE
                   ,'YYYY/MM/DD HH24:MI:SS')
          /*INTO  P_DESCRIPTION,
          	P_WORK_ORDER_ID,
          	P_ITEM_TYPE,
          	P_ITEM_ID,
          	P_CATEGORY_SET_ID,
          	P_CATEGORY_ID,
          	P_PROJECT_ID,
          	P_ADJUSTMENT_ACCOUNT,
          	P_CUTOFF_DATE*/
          INTO  	P_DESCRIPTION_v,
	            	P_WORK_ORDER_ID_v,
	            	P_ITEM_TYPE_v,
	            	P_ITEM_ID_v,
	            	P_CATEGORY_SET_ID_v,
	            	P_CATEGORY_ID_v,
	            	P_PROJECT_ID_v,
	            	P_ADJUSTMENT_ACCOUNT_v,
          		P_CUTOFF_DATE_v
          FROM
            CST_AP_VARIANCE_BATCHES
          WHERE BATCH_ID = LP_BATCH_ID;

Line: 188

          SELECT
            WIP_ENTITY_NAME
          INTO CP_WORK_ORDER
          FROM
            WIP_ENTITIES WE
          WHERE WIP_ENTITY_ID = P_WORK_ORDER_ID_v;

Line: 200

          SELECT
            MEANING
          INTO CP_ITEM_TYPE
          FROM
            MFG_LOOKUPS
          WHERE LOOKUP_TYPE = 'CST_IPV_WIP_ITEM_TYPE'
            AND LOOKUP_CODE = P_ITEM_TYPE_v;

Line: 212

          SELECT
            MEANING
          INTO CP_ITEM_RANGE
          FROM
            MFG_LOOKUPS
          WHERE LOOKUP_TYPE = 'CST_ITEM_RANGE'
            AND LOOKUP_CODE = P_ITEM_OPTION_V;

Line: 223

          SELECT
            CONCATENATED_SEGMENTS
          INTO CP_ITEM
          FROM
            MTL_SYSTEM_ITEMS_KFV
          WHERE ORGANIZATION_ID = P_ORGANIZATION_ID1
            AND INVENTORY_ITEM_ID = P_ITEM_ID_v;

Line: 234

          SELECT
            CATEGORY_SET_NAME
          INTO CP_CATEGORY_SET
          FROM
            MTL_CATEGORY_SETS
          WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID_v;

Line: 244

          SELECT
            CONCATENATED_SEGMENTS
          INTO CP_CATEGORY
          FROM
            MTL_CATEGORIES_KFV
          WHERE CATEGORY_ID = P_CATEGORY_ID_v;

Line: 254

          SELECT
            NAME
          INTO CP_PROJECT
          FROM
            PA_PROJECTS_ALL
          WHERE PROJECT_ID = P_PROJECT_ID_v;

Line: 264

          SELECT
            CONCATENATED_SEGMENTS
          INTO CP_ADJUSTMENT_ACCOUNT
          FROM
            GL_CODE_COMBINATIONS_KFV
          WHERE CODE_COMBINATION_ID = P_ADJUSTMENT_ACCOUNT_v;

Line: 333

      SELECT
        NVL(ITEM_TYPE
           ,0)
      INTO L_SHOPFLOOR
      FROM
        CST_AP_VARIANCE_BATCHES
      WHERE BATCH_ID = LP_BATCH_ID
        AND ROWNUM = 1;

Line: 343

        DELETE FROM CST_AP_VARIANCE_LINES CAVL
         WHERE BATCH_ID = LP_BATCH_ID;

Line: 345

        DELETE FROM CST_AP_VARIANCE_HEADERS CAVH
         WHERE BATCH_ID = LP_BATCH_ID;

Line: 347

        DELETE FROM CST_AP_VARIANCE_BATCHES CAVB
         WHERE BATCH_ID = LP_BATCH_ID;