APPS.INVPUPI2 SQL Statements

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

Line: 18

   SELECT INVENTORY_ITEM_ID,
          TRANSACTION_ID,
          ORGANIZATION_ID,
          PICK_COMPONENTS_FLAG,
          PURCHASING_ITEM_FLAG,
          SHIPPABLE_ITEM_FLAG,
          CUSTOMER_ORDER_FLAG,
          INTERNAL_ORDER_FLAG,
          INVENTORY_ITEM_FLAG,
          ENG_ITEM_FLAG,
          INVENTORY_ASSET_FLAG,
          PURCHASING_ENABLED_FLAG,
          CUSTOMER_ORDER_ENABLED_FLAG,
          INTERNAL_ORDER_ENABLED_FLAG,
          SO_TRANSACTIONS_FLAG,
          MTL_TRANSACTIONS_ENABLED_FLAG,
          STOCK_ENABLED_FLAG,
          BOM_ENABLED_FLAG,
          BUILD_IN_WIP_FLAG,
          CATALOG_STATUS_FLAG,
          RETURNABLE_FLAG,
          COLLATERAL_FLAG,
          TAXABLE_FLAG,
          ALLOW_ITEM_DESC_UPDATE_FLAG,
          INSPECTION_REQUIRED_FLAG,
          RECEIPT_REQUIRED_FLAG,
          RFQ_REQUIRED_FLAG,
          ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
          ALLOW_UNORDERED_RECEIPTS_FLAG,
          ALLOW_EXPRESS_DELIVERY_FLAG,
          MRP_CALCULATE_ATP_FLAG,
          END_ASSEMBLY_PEGGING_FLAG,
          REPETITIVE_PLANNING_FLAG,
          REPLENISH_TO_ORDER_FLAG,
          ATP_COMPONENTS_FLAG,
          ATP_FLAG,
          DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
          ENGINEERING_ECN_CODE,
          SERVICEABLE_PRODUCT_FLAG,
          PREVENTIVE_MAINTENANCE_FLAG,
          TIME_BILLABLE_FLAG,
          MATERIAL_BILLABLE_FLAG,
          EXPENSE_BILLABLE_FLAG,
          PRORATE_SERVICE_FLAG,
          SERVICE_DURATION_PERIOD_CODE,
          INVOICEABLE_ITEM_FLAG,
          INVOICE_ENABLED_FLAG,
          MUST_USE_APPROVED_VENDOR_FLAG,
          OUTSIDE_OPERATION_FLAG,
          COSTING_ENABLED_FLAG,
          CYCLE_COUNT_ENABLED_FLAG,
          AUTO_CREATED_CONFIG_FLAG,
          /*CK 18NOV98 Added new attribute*/
           CHECK_SHORTAGES_FLAG,
	       BOM_ITEM_TYPE,
	       CONTRACT_ITEM_TYPE_CODE,
          --R12 FPC
          GDSN_OUTBOUND_ENABLED_FLAG,
          STYLE_ITEM_FLAG
   FROM   MTL_SYSTEM_ITEMS_INTERFACE
   --3515652: Performance enhancements
   WHERE ((organization_id = org_id) or (all_Org = 1))
   AND   set_process_id  = xset_id
   AND   process_flag in (31, 32, 33, 34 , 35 , 45);

Line: 86

      select meaning
      from   cs_lookups
      where  lookup_type = cp_lookup_type
      and    lookup_code =  cp_lookup_code
      and enabled_flag   = 'Y';

Line: 571

       if  (cr.ALLOW_ITEM_DESC_UPDATE_FLAG <> 'Y' and
                     cr.ALLOW_ITEM_DESC_UPDATE_FLAG <> 'N') then
                                dumm_status := INVPUOPI.mtl_log_interface_err(
                                cr.organization_id,
                                user_id,
                                login_id,
                                prog_appid,
                                prog_id,
                                request_id,
                                cr.TRANSACTION_ID,
                                error_msg,
                                'ALLOW_ITEM_DESC_UPDATE_FLAG',
                                'MTL_SYSTEM_ITEMS_INTERFACE',
                                'INV_IOI_FLAG_Y_N',
                                err_text);

Line: 1177

                SELECT status
                INTO   status
                FROM   mtl_all_primary_uoms_vv
                WHERE  uom_code = cr.service_duration_period_code
                AND    uom_class = time_uom_class;

Line: 1460

        select process_flag into temp_proc_flag
        from   MTL_SYSTEM_ITEMS_INTERFACE
        where inventory_item_id  = cr.inventory_item_id
        -- and   set_process_id + 0 = xset_id  -- fix for bug#8757041,removed + 0
        and   set_process_id = xset_id
        and   process_flag in (31, 32, 33, 34 , 35 , 45)
        and   organization_id    = cr.organization_id
        and   rownum < 2;

Line: 1474

           update MTL_SYSTEM_ITEMS_INTERFACE
           set process_flag = DECODE(status,0,45,35)
           where inventory_item_id  = cr.inventory_item_id
           --and   set_process_id + 0 = xset_id  -- fix for bug#8757041,removed + 0
           and   set_process_id = xset_id
           and   process_flag       = 45
           and   organization_id    = cr.organization_id;