APPS.INVATTR SQL Statements

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

Line: 8

	select
         ORGANIZATION_ID,
	 INVENTORY_ITEM_FLAG,
	 STOCK_ENABLED_FLAG,
	 PURCHASING_ITEM_FLAG,
         INVOICEABLE_ITEM_FLAG,
         BOM_ITEM_TYPE,
	 CUSTOMER_ORDER_FLAG,
	 INTERNAL_ORDER_FLAG
       from mtl_system_items
       where inventory_item_id = item_id
        and organization_id  in ( select organization_id
            from mtl_parameters where master_organization_id =master_org_id
            and organization_id <> master_org_id);

Line: 26

        select attribute_name,
	       control_level
        from MTL_ITEM_ATTRIBUTES
        where control_level = 1
        order by attribute_name desc ;

Line: 137

            update mtl_system_items
		set
		 stock_enabled_flag = decode(B_STOCK_ENABLED,'N','N',stock_enabled_flag),
		 mtl_transactions_enabled_flag = decode(B_MTL_TRANSACTIONS_ENABLED,'N','N',mtl_transactions_enabled_flag),
		 purchasing_enabled_flag = decode(B_PURCHASING_ENABLED,'N','N',purchasing_enabled_flag),
		 invoice_enabled_flag = decode(B_INVOICE_ENABLED,'N','N',invoice_enabled_flag),
		 customer_order_enabled_flag = decode(B_CUSTOMER_ORDER_ENABLED,'N','N',customer_order_enabled_flag),
		 internal_order_enabled_flag = decode(B_INTERNAL_ORDER_ENABLED,'N','N',internal_order_enabled_flag),
	        bom_enabled_flag = decode(B_BOM_ENABLED,'N','N',bom_enabled_flag),
                build_in_wip_flag = decode(B_BUILD_IN_WIP,'N','N',build_in_wip_flag)
		where inventory_item_id = item_id
		  and organization_id = cr.organization_id;